Timestamp Functions¶
BodoSQL currently supports the following Timestamp functions:
ADDDATECURDATECURRENT_DATECURRENT_TIMECURRENT_TIMESTAMPDATE_ADDDATE_FORMATDATE_FROM_PARTSDATE_PARTDATE_SUBDATE_TRUNCDATEADDDATEDIFFDATEFROMPARTSDAYNAMEEXTRACTFROM_DAYSFROM_UNIXTIMEGETDATEHOURLAST_DAYLOCALTIMELOCALTIMESTAMPMAKEDATEMICROSECONDMINUTEMONTHMONTH_NAMEMONTHNAMENOWQUARTERSECONDSTR_TO_DATESUBDATESYSDATESYSTIMESTAMPTIME_FROM_PARTSTIME_SLICETIMEADDTIMEFROMPARTSTIMESTAMP_FROM_PARTSTIMESTAMP_LTZ_FROM_PARTSTIMESTAMP_NTZ_FROM_PARTSTIMESTAMP_TZ_FROM_PARTSTIMESTAMPADDTIMESTAMPDIFFTIMESTAMPFROMPARTSTIMESTAMPLTZFROMPARTSTIMESTAMPNTZFROMPARTSTIMESTAMPTZFROMPARTSTO_DAYSTO_SECONDSTRUNCUNIX_TIMESTAMPUTC_DATEUTC_TIMESTAMPWEEKWEEKDAYWEEKISOWEEKOFYEARYEARYEAROFWEEKISOYEARWEEK