Date Functions

Date functions return date and time information and calculate or convert time zones.

TDV supports the date functions listed in the table.

Date Function	Comments
ADD_MONTHS	ADD_MONTHS
AGE	AGE
AT TIME ZONE	AT TIME ZONE
CALENDAR MONTH	CALENDAR_MONTH
CALENDAR QUARTER	CALENDAR_QUARTER
CALENDAR YEAR	CALENDAR_YEAR
CLOCK MILLIS	CLOCK_MILLIS
CLOCK STR	CLOCK_STR
CLOCK_TIMESTAMP	CLOCK_TIMESTAMP
CURRENT_DATE	CURRENT_DATE,
CURRENT_TIME	CURRENT_TIME,
CURRENT_TIMESTAMP	CURRENT_TIMESTAMP,
DATE	DATE
DATEADD	DATEADD
DATE_ADD	DATE_ADD
DATE_ADD_MILLIS	DATE_ADD_MILLIS
DATE_ADD_STR	DATE_ADD_STR
DATEDIFF	DATEDIFF
DATE_DIFF	See DATEDIFF,
DATE_DIFF_MILLIS	DATE_DIFF_MILLIS
DATE_DIFF_STR	DATE_DIFF_STR
DATENAME	DATENAME
DATEPART	DATEPART
DATE_PART	DATE_PART
DATE_PART_MILLIS	DATE_PART_MILLIS
DATE_PART_STR	DATE_PART_STR
DATETRUNC	DATETRUNC
DATE_TRUNC	DATE_TRUNC
DATE_TRUNC_MILLIS	DATE_TRUNC_MILLIS
DATE_TRUNC_STR	DATE_TRUNC_STR
DATE_SUB	DATE_SUB
DAY	ARRAY_POSITION,
DAYNAME	DAYNAME
DAYOFMONTH	DAYOFMONTH
DAYOFWEEK	DAYOFWEEK
DAYOFWEEK_ISO	DAYOFWEEK_ISO
DAYOFYEAR	DAYOFYEAR
DAYS	DAYS
DAYS_BETWEEN	DAYS_BETWEEN
DAYS_IN_MONTH	DAY_IN_MONTH
DAY_IN_WEEK	DAY_IN_WEEK
DAY_IN_YEAR	DAY_IN_YEAR
DAY_ONLY	DAY_ONLY
DBTIMEZONE	DBTIMEZONE
EXTRACT	See EXTRACT
EXTRACTDAY	EXTRACTDAY
EXTRACTDOW	EXTRACTDOW
EXTRACTDOY	EXTRACTDOY
EXTRACTEPOCH	EXTRACTEPOCH
EXTRACTHOUR	EXTRACTHOUR
EXTRACTMICROSECOND	EXTRACTMICROSECOND
EXTRACTMILLISECOND	EXTRACTMILLISECOND
EXTRACTMINUTE	EXTRACTMINUTE
EXTRACTMONTH	EXTRACTMONTH
EXTRACTQUARTER	EXTRACTQUARTER
EXTRACTSECOND	EXTRACTSECOND
EXTRACTWEEK	EXTRACTWEEK
EXTRACTYEAR	EXTRACTYEAR
FISCAL_MONTH	FISCAL_MONTH
FISCAL_QUARTER	FISCAL_QUARTER
FISCAL_YEAR	FISCAL_YEAR
FRACTIONALSECONDS	FRACTIONALSECONDS
FROM_UNIXTIME	FROM_UNIXTIME
GETUTCDATE	GETUTCDATE
HOUR	HOUR
HOUR_IN_DAY	HOUR_IN_DAY
ISFINITE	ISFINITE
JULIAN_DAY	JULIAN_DAY
LAST_DAY	LAST_DAY
LOCALTIME	LOCALTIME
LOCALTIMESTAMP	LOCALTIMESTAMP
MAXDATETIME	MAXDATETIME
MICROSECOND	MICROSECOND
MIDNIGHT_SECONDS	MIDNIGHT_SECONDS
MILLIS	MILLIS
MILLIS_TO_STR	MILLIS_TO_STR
MILLIS_TO_UTC	MILLIS_TO_UTC
MINDATETIME	MINDATETIME
MINUTE	MAXDATETIME
MONTH	ARRAY_POSITION,
MONTHNAME	MONTHNAME
MONTHS_BETWEEN	MONTHS_BETWEEN,
NEW_TIME	NEW_TIME
NEXT_DAY	NEXT_DAY
NOW	NOW
NOW_MILLIS	NOW_MILLIS
NOW_STR	NOW_STR
NUMTODSINTERVAL	NUMTODSINTERVAL,
NUMTOYMINTERVAL	NUMTOYMINTERVAL,
QUARTER	QUARTER
ROUND	ROUND
SECOND	SECOND
STATEMENT_TIMESTAMP
STR_TO_MILLIS	STR_TO_MILLIS
STR_TO_UTC	STR_TO_UTC
STR_TO_ZONE_NAME	STR_TO_ZONE_NAME
SYSDATE	SYSDATE
TIME	TIME
TIME_SLICE	TIME_SLICE
TIMEOFDAY	TIMEOFDAY
TIMESTAMP_ROUND	TIMESTAMP_ROUND
TIMESTAMP_TRUNC	TIMESTAMP_TRUNC
TIMESTAMPADD	TIMESTAMPADD
TIMESTAMPDIFF	TIMESTAMPDIFF
TOTALOFFSETMINUTES	TOTALOFFSETMINUTES
TOTALSECONDS	TOTALSECONDS
TRANSACTION_TIMESTAMP	TRANSACTION_TIMESTAMP
TZ_OFFSET	TZ_OFFSET,
TZCONVERTOR	TZCONVERTOR ,
UNIX_TIMESTAMP	UNIX_TIMESTAMP
UTC_TO_TIMESTAMP	UTC_TO_TIMESTAMP,
WEEK	WEEK
WEEK_IN_MONTH	WEEK_IN_MONTH
WEEK_IN_YEAR	WEEK_IN_YEAR
WEEK_ISO	WEEK_ISO
WEEKNUM	WEEKNUM
YEAR	ARRAY_POSITION,
YEAR_ISO	YEAR_ISO

Subtopics