datafusion_functions::datetime

Module expr_fn

Source

Functionsยง

  • current_date
    returns current UTC date as a Date32 value
  • current_time
    returns current UTC time as a Time64 value
  • date_bin
    coerces an arbitrary timestamp to the start of the nearest specified interval
  • date_part
    extracts a subfield from the date
  • date_trunc
    truncates the date to a specified level of precision
  • from_unixtime
    converts an integer to RFC3339 timestamp format string
  • make_date
    make a date from year, month and day component parts
  • now
    returns the current timestamp in nanoseconds, using the same value for all instances of now() in same statement
  • to_char
    Returns a string representation of a date, time, timestamp or duration based on a Chrono pattern.
  • to_date
  • to_local_time
    converts a timezone-aware timestamp to local time (with no offset or timezone information), i.e. strips off the timezone from the timestamp
  • to_timestamp
    converts a string and optional formats to a Timestamp(Nanoseconds, None)
  • to_timestamp_micros
    converts a string and optional formats to a Timestamp(Microseconds, None)
  • to_timestamp_millis
    converts a string and optional formats to a Timestamp(Milliseconds, None)
  • to_timestamp_nanos
    converts a string and optional formats to a Timestamp(Nanoseconds, None)
  • to_timestamp_seconds
    converts a string and optional formats to a Timestamp(Seconds, None)
  • to_unixtime
    converts a string and optional formats to a Unixtime