Skip to Main Content

Oracle Database Discussions

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!

TIME ZONE TZH:TZM and TZR TZD format

a5859063-1bb7-4a5e-a3dc-0505c1e768cdApr 5 2017 — edited Apr 7 2017

Hi,

I am working with TIMESTAMP WITH LOCAL TIMEZONE data type  and I am observing a difference while displaying the values of this column.

When I set my time zone to 'America/Los_angeles'  in TZR TZD format, which is UTC-07:00, I see following values

A)

         4 11-MAR-17 10.30.00.000000 AM

         5 12-MAR-17 11.30.00.000000 AM

However, when I set my time_zone in TZH:TZM format explicitly to UTC-07:00, I see following values

B)

         4 11-MAR-17 11.30.00.000000 AM

         5 12-MAR-17 11.30.00.000000 AM

There is a 1 hour shift in time for 11-MAR-17.

I am expecting to see the same result as in B).

Thanks

This post has been answered by unknown-7404 on Apr 6 2017
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 5 2017
Added on Apr 5 2017
8 comments
6,217 views