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