All Forums Database
uco 15 posts Joined 12/13
31 May 2014
Teradata function from_gmt2

Hi
I need to convert these statments from using  AT TIMEZONE to FROM_GMT2.  Help is very much appreciated
c_timestamp is a column of timestamp(0) type
TO_CHAR(CAST(CAST(c_timestamp AT TIME ZONE 'America Mountain' AS VARCHAR(19)) AS TIMESTAMP(0)),'YYYY-MM-DD HH24:MI:SS') AS C_TIMESTAMP_MDT
TO_CHAR(CAST(CAST(c_timestamp AT TIME ZONE 'America Eastern' AS VARCHAR(19)) AS TIMESTAMP(0)),'YYYY-MM-DD HH24:MI:SS') AS C_TIMESTAMP_EDT
TO_CHAR(CAST(CAST(c_timestamp AT TIME ZONE 'GMT-7' AS VARCHAR(19)) AS TIMESTAMP(0)),'YYYY-MM-DD HH24:MI:SS') AS C_TIMESTAMP_MST

You must sign in to leave a comment.