Oracle Time Zone Conversion

I’ll elaborate this later on, but if you ever encounter the problem of having to comvert a UTC/GMT time to a TimeZone with Daylight Saving (or the other way around), this statement will do:

select to_char(FROM_TZ(CAST(c.creation_date AS TIMESTAMP), ‘Europe/Berlin’)
AT TIME ZONE ‘GMT’,’DD.MM.YYYY HH24:MI:SS’) as creation_date From CREDIT_CARD c

Source TZ: Europe/Berlin
Target TZ: GMT

 

Here’s the reference link:

http://download.oracle.com/docs/cd/B19306_01/server.102/b14225/ch4datetime.htm#i1007699

Advertisements
This entry was posted in Uncategorized and tagged , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s