Teradata - Built-in Functions


Advertisements

Teradata provides built-in functions which are extensions to SQL. Following are the common built-in functions.

Function Result
SELECT DATE; Date
--------
16/01/01
SELECT CURRENT_DATE; Date
--------
16/01/01
SELECT TIME; Time
--------
04:50:29
SELECT CURRENT_TIME; Time
--------
04:50:29
SELECT CURRENT_TIMESTAMP; Current TimeStamp(6)
--------------------------------
2016-01-01 04:51:06.990000+00:00
SELECT DATABASE; Database
------------------------------
TDUSER
Advertisements