Teradata 简明教程

Teradata - Built-in Functions

Teradata 提供内置函数，这是对 SQL 的扩展。以下是常见的内置函数。

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