access_time 11 months ago languageEnglish
more_vert

Convert TimeStamp to Date in Teradata

visibility 8,364 comment 0

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. 

copyright This page is subject to Site terms.
Like this article?
Share on

Please log in or register to comment.

account_circle Log in person_add Register

Log in with external accounts

Follow Kontext

Get our latest updates on LinkedIn.

Want to contribute on Kontext to help others?

Learn more

More from Kontext

visibility 2570
thumb_up 0
access_time 12 months ago
visibility 1044
thumb_up 0
access_time 11 months ago