Getting Current date and time in Teradata

The following queries will help in getting date and times.

1. Only dates
SELECT CURRENT_DATE

SELECT DATE


2. Only Time
SELECT CURRENT_TIME


3. Date and time
SELECT CURRENT_TIMESTAMP

SELECT CAST(CAST(CURRENT_DATE AS FORMAT 'YYYY-MM-DD') || ' ' || CAST(CAST(CURRENT_TIME AS FORMAT 'HH:MI:SS') AS CHAR(8)) AS TIMESTAMP(0));

SELECT CAST(CURRENT_DATE AS TIMESTAMP(0)) + ((CURRENT_TIME - TIME '00:00:00') HOUR TO SECOND(0));