Is it possible to get the timestamp to display the timezone like this using SQL? 2011-04-08 09:16:10 PM Central Standard Time
What I have so far:
SQL: SELECT current_timestamp as myDefaultTimestamp , cast(cast(current_timestamp AS TIMESTAMP(6) FORMAT 'YYYY-MM-DDBHH:MI:SS.S(F)Z') as varchar(40)) as myTimeZone , cast( cast(current_timestamp AS TIMESTAMP(6) FORMAT 'E3,BM4BDD,BY4BHH:MI:SSDS(F)') as varchar(40)) as myTimeZone2
I've tried to find that format but I'm affraid there is no such format. May be someone knows better.
I don't know what You exactly need but if You just need name of time zone like Pacific Daylight Time,Middle European Time etc You can create dictionary with two columns(hour,zone_name)and join on timezone_hour from Your timestamp.