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 stackoverflow.com/questions/14070572/…

Peeyush
– Peeyush

2013-05-31 02:09:08 +00:00
Commented May 31, 2013 at 2:09 — Peeyush
– Peeyush, Commented May 31, 2013 at 2:09

CodeChimp · Accepted Answer · 2013-05-31 02:23:35Z

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, 2013 at 2:23

CodeChimp

8,1946 gold badges45 silver badges80 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Evgeniy Dorofeev · Accepted Answer · 2013-05-31 02:13:30Z

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, 2013 at 2:13

Evgeniy Dorofeev

137k31 gold badges209 silver badges288 bronze badges

Comments

amicngh · Accepted Answer · 2013-05-31 02:51:33Z

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, 2013 at 2:51

amicngh

7,9293 gold badges37 silver badges55 bronze badges

2 Comments

Jonathan Over a year ago

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 docjar.com/html/api/java/util/Date.java.html (line 252)

BPS Over a year ago

@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.

Collectives™ on Stack Overflow

Convert java.sql.Timestamp to local timezone

3 Answers 3

Comments

Comments

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related