HI All,
Version: Java 1.5
Database: Oracle 10g
I have a date column in a table. Using the JDBC call I retrieve the date using:
Timestamp datetime = ResultSet.getTimestamp();
Now I want to convert this into a different time zone. For Example, if the database has "10-APR-2009 22:00:00" and if the JVM's timezone is America/Los_Angeles, it will be read as "10-APR-2009 22:00:00 PST". Now I want to convert this into IST time and date. So, it should be converted "11-APR-2009 10:30:00 IST".
Please let me know how to do this.
Regards
Version: Java 1.5
Database: Oracle 10g
I have a date column in a table. Using the JDBC call I retrieve the date using:
Timestamp datetime = ResultSet.getTimestamp();
Now I want to convert this into a different time zone. For Example, if the database has "10-APR-2009 22:00:00" and if the JVM's timezone is America/Los_Angeles, it will be read as "10-APR-2009 22:00:00 PST". Now I want to convert this into IST time and date. So, it should be converted "11-APR-2009 10:30:00 IST".
Please let me know how to do this.
Regards