Date and Time Functions

This section provides reference information for the date and time functions in PlaidCloud Lakehouse.

ADD_MONTHS

ADDDATE

CONVERT_TZ

CURDATE

CURRENT_DATE

CURRENT_TIME

CURRENT_TIMESTAMP

CURRENT_TIMEZONE

CURTIME

DATE

DATE_ADD

DATE_DIFF

DATE_FORMAT

DATE_SLICE

DATE_SUB

DATE_TRUNC

DATEDIFF

DAY

DAYNAME

DAYOFMONTH

DAYOFWEEK

DAYOFWEEK_ISO

DAYOFYEAR

DAYS_ADD

DAYS_DIFF

DAYS_SUB

FROM_DAYS

FROM_UNIXTIME

HOUR

HOURS_ADD

HOURS_DIFF

HOURS_SUB

JODATIME_FORMAT

LAST_DAY

LOCALTIME

LOCALTIMESTAMP

MAKEDATE

MICROSECONDS_ADD

MICROSECONDS_SUB

MILLISECONDS_DIFF

MINUTE

MINUTES_ADD

MINUTES_DIFF

MINUTES_SUB

MONTH

MONTHNAME

MONTHS_ADD

MONTHS_DIFF

MONTHS_SUB

NEXT_DAY

NOW

PREVIOUS_DAY

QUARTER

SEC_TO_TIME

SECOND

SECONDS_ADD

SECONDS_DIFF

SECONDS_SUB

STR_TO_DATE

STR_TO_JODATIME

STR2DATE

SUBDATE

TIME_FORMAT

TIME_SLICE

TIME_TO_SEC

TIMEDIFF

TIMESTAMP

TIMESTAMPADD

TIMESTAMPDIFF

TO_DATE

TO_DATETIME

TO_DATETIME_NTZ

TO_DAYS

TO_ISO8601

TO_TERA_DATE

TO_TERA_TIMESTAMP

UNIX_TIMESTAMP

UTC_TIME

UTC_TIMESTAMP

WEEK

WEEK_ISO

WEEKDAY

WEEKOFYEAR

WEEKS_ADD

WEEKS_DIFF

WEEKS_SUB

YEAR

YEARS_ADD

YEARS_DIFF

YEARS_SUB

YEARWEEK