How to convert java.sql.Timestamp value from EST to UTC timezone

Question

I have a java.sql.Timestamp variable in local timezone with following formatting

2011-07-21 00:40:37

I need to convert it to UTC

I asked this question to see if it can be done by mysql, but received no answers.

I guess I have to somehow do it in java code before substituting it in the query

@Jon That won't work for me because it doesn't take into account the variable DST. This code will be deployed in multiple timezones and I will need it to be accurate in UTC conversion based on its location and time of year... — storm_to
– storm_to, Commented Jul 25, 2011 at 21:03
MySQL solution SELECT CONVERT_TZ( NOW(), @@session.time_zone, '+00:00' ) — storm_to
– storm_to, Commented Feb 14, 2012 at 16:54

plor · Accepted Answer · 2011-07-25 20:59:46Z

2

I recommend using Joda Time to parse the timestamp. You'll need to set the timezone to EST and then get the UTC time from there. You could do the same thing with the generic Java Date, but Joda is easier to work with.

answered Jul 25, 2011 at 20:59

plor

2822 silver badges12 bronze badges

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

2 Comments

storm_to Over a year ago

Is there a way to read local timezone? EST was just an example, but it could be any timezone

storm_to Over a year ago

After a closer look at Joda time I see it has public long convertLocalToUTC(long instantLocal, boolean strict) Looks like setting the strict argument to True will make it account for DST if applicable. Hopefully it will turn out to be exactly what I need. Won't know for sure until after QA's done

Collectives™ on Stack Overflow

How to convert java.sql.Timestamp value from EST to UTC timezone

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related