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 |