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: Casts String to Date
​DATE_ADD: Adds an interval value of type unit to timestamp. Subtraction can be performed by using a negative value
​DATE_DIFF: Returns timestamp2 - timestamp1 expressed in terms of unit
​DATE_TRUNC: Truncate a date to a given unit
​DAY: Returns the day of the month from timestamp
​DAY_OF_WEEK: Returns the ISO day of the week from timestamp. values range from 1 (Monday) to 7 (Sunday).
​DAY_OF_YEAR: Returns the day of the year from timestamp. values range from 1 to 366.
​EXTRACT_TIMESTAMP: Convert a date or timestamp string to a date or timestamp, autodetecting the date format.
​FORMAT_DATETIME: Convert datetime into string
​FROM_ISO8601_DATE: Parses the ISO 8601 formatted string into a date
​FROM_UNIXTIME: Convert epoch seconds to a timestamp
​HOUR: Returns the hour of the day from timestamp. values range from 0 to 23.
​MILLISECOND: Returns the millisecond of the second from timestamp
​MINUTE: Returns the minute of the hour from timestamp
​MONTH: Returns the month of the year from timestamp
​QUARTER: Returns the quarter of year from timestamp. Values range from 1 to 4.
​RUN_END_TIME: gets the job's execution end time
​RUN_START_TIME: gets the job's execution start time
​SECOND: Returns the second of the minute from timestamp
​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
​TO_UNIX_EPOCH_MILLIS: Convert a date to it's Epoch (unix) seconds representation
​TO_UNIX_EPOCH_SECONDS: Convert a date to it's Epoch (unix) seconds representation
​WEEK: Returns the ISO week of the year from timestamp. Values range from 1 to 53.
​YEAR_OF_WEEK: Returns the year of ISO week from timestamp
​YEAR: Returns the year from timestamp
REGEXP_REPLACE
ADD_TIME_ZONE_OFFSET
Last modified 14d ago