CODEWITHSUNDEEP
javajdbc
kal
kal

Reputation: 29381

Java ResultSet how to getTimeStamp in UTC

The database has data in UTC and when I try to get data 

java.util.Calendar cal = Calendar.getInstance();
cal.setTimeZone(TimeZone.getTimeZone("UTC"));
java.sql.Timestamp ts = resultSet.getTimestamp(PUBLISH_TIME);
cal.setTime(ts);

Is there anything wrong with this?

Upvotes: 14

Views: 34332

Answers (2)

akf
akf

Reputation: 39495

Your DateFormat instance is most likely displaying the value in local time. When displaying your value, give this a try:

java.util.Calendar cal = Calendar.getInstance();
cal.setTimeZone(TimeZone.getTimeZone("UTC"));
java.sql.Timestamp ts = resultSet.getTimestamp(PUBLISH_TIME);
cal.setTime(ts);

SimpleDateFormat sdf = new SimpleDateFormat("HH:mm:ss z");
sdf.setTimeZone(TimeZone.getTimeZone("UTC"));
System.out.println(sdf.format(cal.getTime()));

EDIT: to your comment:

What if I use GMT, would that be an issue in SimpleDateFormat

SimpleDateFormat can use general timezones (GMT +/- n), RFC822, and text ("if they have names" as the JavaDoc states - see this post for info on the names).

Upvotes: 6

Subu
Subu

Reputation: 411

java.util.Calendar cal = Calendar.getInstance(); 
cal.setTimeZone(TimeZone.getTimeZone("UTC")); 
java.sql.Timestamp ts = resultSet.getTimestamp(PUBLISH_TIME, cal);

This should do the trick!

Upvotes: 35

Related Questions