Date & Time Functions

This section provides reference information for the datetime-related functions in PlaidCloud Lakehouse.

Conversion Functions

• DATE
• TO_MONTH
• MONTH
• TO_DATE
• TO_DATETIME
• TODAY
• TO_DAY_OF_MONTH
• DAY
• TO_DAY_OF_WEEK
• TO_DAY_OF_YEAR
• TO_HOUR
• TO_MINUTE
• TO_MONDAY
• TOMORROW
• TO_QUARTER
• QUARTER
• TO_SECOND
• TO_START_OF_DAY
• TO_START_OF_FIFTEEN_MINUTES
• TO_START_OF_FIVE_MINUTES
• TO_START_OF_HOUR
• TO_START_OF_ISO_YEAR
• TO_START_OF_MINUTE
• TO_START_OF_MONTH
• TO_START_OF_QUARTER
• TO_START_OF_SECOND
• TO_START_OF_TENMINUTES
• TO_START_OF_WEEK
• TO_START_OF_YEAR
• TOTIMESTAMP
• TO_UNIX_TIMESTAMP
• TO_WEEK_OF_YEAR
• WEEK
• WEEKOFYEAR
• TO_YEAR
• YEAR
• TO_YYYYMM
• TO_YYYYMMDD
• TO_YYYYMMDDHH
• TO_YYYYMMDDHHMMSS

Date Arithmetic Functions

• ADD INTERVAL
• DATE_ADD
• DATE_SUB
• SUBTRACT INTERVAL

Date Information Functions

• DATE_PART
• DATE_DIFF
• DATE_FORMAT
• DATE_TRUNC
• NOW
• CURRENT_TIMESTAMP

Others

• EXTRACT
• TIME_SLOT
• TIMEZONE
• YESTERDAY