Hibernate 3.0.5, JDK 1.4.2.
I defined several Oracle columns TIMESTAMP, and I'm mapping them to java.sql.Timestamp with Hibernate. After I got the application going, I realized that I probably should have defined the columns as TIMESTAMP WITH TIMEZONE. In some situations, I'm writing to the table and reading from it in a different timezone (I know which tables that's happening in).
If I make this database change (and data conversion), do I have to do anything to my Hibernate mapping so the following scenario works?
* From the Pacific timezone, write a timestamp value equivalent to "8:00 AM PST" into the column.
* From the Central timezone, read the value from the database and see that it is "10:00 AM CST".
|