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