Available on crate feature
datetime_expressions only.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