Teradata Built-In Functions

Teradata provides built-in functions, which are extensions to SQL. The Built-in functions return information about the system.

Built-in functions are sometimes referred to as individual registers. It can be used anywhere that a literal can appear.

If a SELECT statement that contains a built-in function references a table name, then the result of the query contains one row for every row of the table that satisfies the search condition.

Some common built-in functions are listed below with examples, such as:

S. No.	Function	Example
1	SELECT DATE;	Date- 2018/02/10
2	SELECT CURRENT_DATE;	Date- 2020/05/23
3	SELECT TIME;	Time- 09:02:00
4	SELECT CURRENT_TIME;	Time- 10:01:13
5	SELECT CURRENT_TIMESTAMP;	Current TimeStamp(6)- 2020-05-23 10:01:13.990000+00.00
6	SELECT DATABASE;	Database- TDUSER