Convert java.sql.Timestamp to local timezone

Question

I am retrieving results from a timestamp mysql database column. I need to convert these results to my local timezone.Timestamp timestamp = rs.getTimestamp("mytimestamp");

refer this http://stackoverflow.com/questions/14070572/is-java-sql-timestamp-timezone-specific — Peeyush, May 31 '13 at 02:09

score 1 · Answer 1 · answered May 31 '13 at 02:13

1

java.sql.Timestamp just like java.util.Date which it extends holds time since since January 1, 1970, 00:00:00 GMT with the only difference that it also holds nanos (see API). It does not depend on time zone and you cannot convert it to local time zone.

answered May 31 '13 at 02:13

Evgeniy Dorofeev

133,369
30
199
275

score 1 · Accepted Answer · answered May 31 '13 at 02:23

1

I think this might work:

Calendar calendar = Calendar.getInstance();
calendar.setTimeInMillis(timestamp.getTime());

I believe they are both based on epoch.

answered May 31 '13 at 02:23

CodeChimp

8,016
5
41
79

score 0 · Answer 3 · answered May 31 '13 at 02:51

0

java.sql.Timestampobjects don't have time zones - they are just like java.util.Date. However you can display time in your TimeZone like

 Calendar localTime = Calendar.getInstance(TimeZone.getDefault());
 localTime .setTimeInMillis(timeStamp.getTime());

answered May 31 '13 at 02:51

amicngh

7,831
3
35
54

Unfortunately Timestamp does have zones (inherited from java.util.Date) depending on which constructor is used. Some JDBC drivers still use the deprecated constructor in which case the local timezone is selected. See http://www.docjar.com/html/api/java/util/Date.java.html (line 252) – Jonathan Apr 02 '14 at 16:48
@Jonathan , neither Date nor Timestamp has time zones though they are related to UTC in a way. Any hint in the javadoc that they have time zones was deprecated in Java 1.1 back in early 1997. Your comment refers to such a deprecated method. Notice that there is no getTimeZone method in Date as there is in Calendar. – BPS Sep 10 '15 at 19:46

Convert java.sql.Timestamp to local timezone

3 Answers3