Date and Time Functions (Lakehouse v2)
This section provides reference information for the date and time functions in PlaidCloud Lakehouse.
Functions
Section titled “Functions”- ADD_MONTHS
- ADDDATE
- CONVERT_TZ
- CURDATE
- CURRENT_DATE
- CURRENT_TIME
- CURRENT_TIMESTAMP
- CURRENT_TIMEZONE
- CURTIME
- DATE_ADD
- DATE_DIFF
- DATE_FORMAT
- DATE_SLICE
- DATE_SUB
- DATE_TRUNC
- DATE
- DATEDIFF
- DAY
- DAYNAME
- DAYOFMONTH
- DAYOFWEEK_ISO
- DAYOFWEEK
- 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_NTZ
- TO_DATETIME
- TO_DAYS
- TO_ISO8601
- TO_TERA_DATE
- TO_TERA_TIMESTAMP
- UNIX_TIMESTAMP
- UTC_TIME
- UTC_TIMESTAMP
- WEEK_ISO
- WEEK
- WEEKDAY
- WEEKOFYEAR
- WEEKS_ADD
- WEEKS_DIFF
- WEEKS_SUB
- YEAR
- YEARS_ADD
- YEARS_DIFF
- YEARS_SUB
- YEARWEEK