Teradata function from_gmt2

Database
uco
Enthusiast

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