Convert TimeStamp to Date in Teradata

Current timestamp

Function CURRENT_TIMESTAMP can be used to retrieve the current timestamp:

SELECT CURRENT_TIMESTAMP;

Sample output:

20/09/2020 20:55:35.390000-04:00

Convert TimeStamp to Date

Function CAST can be used to convert TimeStamp to DATE.

SELECT CAST(CURRENT_TIMESTAMP AS DATE)

Sample output:

20/09/2020

Convert Date to TimeStamp

SELECT CAST(CURRENT_DATE AS TIMESTAMP(6));

Sample output:

20/09/2020 00:00:00.000000

Convert Varchar to TimeStamp

SELECT CAST('2017-10-15 23:59:59.999999 +10:00' AS TIMESTAMP(6) WITH TIME ZONE FORMAT 'YYYY-MM-DDBHH:MI:SS.S(6)BZ');

Sample output:

15/10/2017 23:59:59.999999+10:00

More examples

Refer to Teradata Tutorial – DateTime Related Functions and Examples for more example about Teradata DATE and TIME related function.