88
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 |
Next TopicTeradata Aggregate Functions