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:

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: Logo

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

Google+ photo

You are commenting using your Google+ 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 )


Connecting to %s