|
Archives of the TeradataForumMessage Posted: Mon, 20 Feb 2012 @ 21:06:50 GMT
I am forwarding this post from Teradata Database software engineer Prama Agarwal, who is a subject matter expert on this feature: -----Forwarded Message----- Catherine, Teradata also provides support to cast these columns to different timezones. sel current_timestamp at 'gmt' (title 'GMT TIME'), current_timestamp at 'america pacific' (title 'America Pacific TIME'), current_timestamp at 'america eastern' (title 'America Eastern TIME'); *** Query completed. One row found. 3 columns returned. *** Total elapsed time was 1 second. GMT TIME 2012-02-20 20:42:49.170000+00:00 America Pacific TIME 2012-02-20 12:42:49.170000-08:00 America Eastern TIME 2012-02-20 15:42:49.170000-05:00 sel j from tswz_at; *** Query completed. One row found. One column returned. *** Total elapsed time was 1 second. j -------------------------------- 2012-02-20 12:32:40.700000-08:00 sel j at 'europe eastern' from tswz_at; *** Query completed. One row found. One column returned. *** Total elapsed time was 2 seconds. j AT TIME ZONE 'europe eastern' -------------------------------- 2012-02-20 22:32:40.700000+02:00 Thanks, Prama
| ||||||||||||||||||||||||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||||||||||||||||||||||
Copyright 2016 - All Rights Reserved | ||||||||||||||||||||||||||||||||||||||||||||||||
Last Modified: 15 Jun 2023 | ||||||||||||||||||||||||||||||||||||||||||||||||