Teradata Tutorial on Teradata Builtin Functions
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 |