Contact Support

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

PreviousREGEXP_REPLACENextADD_TIME_ZONE_OFFSET

Last updated