Convert TimeStamp to Date in Teradata
insights Stats
warning Please login first to view stats information.
toc Table of contents
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.
info Last modified by Raymond 12 days ago
copyright
This page is subject to Site terms.
comment Comments
No comments yet.