Date and time functions
This section describes the following date and time functions:
-
ADD_TIME_ZONE_OFFSET
: Add a timezone offset to a date. The timezone offset can be in any of the standard formats accepted by Java's ZoneId.of method (America/New_York, +02:00, etc.) -
DATE_ADD
: Adds an interval value of type unit to timestamp. Subtraction can be performed by using a negative value -
DAY_OF_WEEK
: Returns the ISO day of the week from timestamp. values range from 1 (Monday) to 7 (Sunday). -
EXTRACT_TIMESTAMP
: Convert a date or timestamp string to a date or timestamp, autodetecting the date format. -
SUBTRACT_TIME_ZONE_OFFSET
: Subtract a timezone offset from a date. The timezone offset can be in any of the standard formats accepted by Java's ZoneId.of method (America/New_York, +02:00, etc.) -
TO_UNIXTIME
: Convert a date to its Epoch (unix) seconds representation, with fractional milliseconds
Last modified 14d ago