TIMESTAMP: FORMAT - TimeZone

Database
Junior Supporter

TIMESTAMP: FORMAT - TimeZone

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

RESULTS:
myDefaultTimestamp
2011-04-08 21:16:10.110000+00:00

myTimeZone
2011-04-08 21:16:10.110000

myTimeZone2
Fri, April 08, 2011 21:16:10.110000

1 REPLY
Enthusiast

Re: TIMESTAMP: FORMAT - TimeZone

Hi

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.