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

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

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

Locked Post

New comments cannot be posted to this locked post.

Locked on May 5 2017

Added on Apr 5 2017

#general-database-discussions

8 comments

6,217 views