Description
Name: boT120536 Date: 01/30/2001
java version "1.2.2"
Java HotSpot(TM) Client VM (1.3.0, mixed mode, internal release build)
Your reply to Bug ID 4107152 is unacceptable. SQL data bases store time zone information, but there is no way to access that information.
The SQL standard defines data types TIME WITH TIME ZONE and TIMESTAMP WITH TIME ZONE. These data types store time zone information. Many data bases support these data types. According to "JDBC API Tutorial and Reference, Second Edition" page 870: "... the driver takes into account the time zone, information a DBMS may or may not store." So it seems that it is the drivers responsibility to supply a time or timestamp that is "corrected" to UTC. But there is still no way to find out exactly what time zone is stored in the data.
Consider this simple problem: You have a column declared TIMESTAMP WITH TIME ZONE in a data base, and you want to print it out, complete with the time zone. How do you do it? You can see the time zone in the data base, but you can't see it through JDBC. What do you do?
(Review ID: 114252)
======================================================================