SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

timezone conversion

951193Nov 13 2014 — edited Nov 13 2014

Hi Team,

Need a help to perform TZ conversion. We have a requirement we will getting records in a text file. The time stamp column in the text file will be '2013-01-17T11:50:11.400-08:00'

The ETL job (datastage) will have to extract records from file and load to Oracle database. While loading we need to convert to MT.

Meaning..

step 1: the timestamp will be 8 hrs less than UTC. Hence we need to add 8 hrs to 2013-01-17T11:50:11.400

step 2: then to convert to MT (mountain timezone) we need to add "-07:00".

Can anyone please help me how to perform this in oracle database?

Thanks

Krishna

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 11 2014

Added on Nov 13 2014

1 comment

707 views