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:
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(current_timestamp AS TIMESTAMP(6)
FORMAT 'E3,BM4BDD,BY4BHH:MI:SSDS(F)') as varchar(40)) as myTimeZone2
Fri, April 08, 2011 21:16:10.110000
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.