How to obtain the time zone stored in a TIMESTAMP WITH TIME ZONE column?
castorpApr 3 2009 — edited Apr 6 2009Hello,
I have a table with a column of type TIMESTAMP WITH TIME ZONE.
When retrieving values from this column I can't seem to get the time zone information that is stored in the column. I know the Javadocs for the Oracle driver state that the bytes 11 and 12 of the internal array somehow contain this information but there is no further information on the format nor any methods in the public API to actually get the timezone that was specified when the value was inserted.
Now, there must be a way because SQL Developer does display the information but as it isn't OpenSource I can't peek into the code.
So how to I obtain that information?
Regards
Thomas