English 中文(简体)
Teradata - Built-in Functions
  • 时间:2024-12-22

Teradata - Built-in Functions


Previous Page Next Page  

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