storm_to
Reputation: 1575
How to convert java.sql.Timestamp value from EST to UTC timezone
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
Upvotes: 0
Views: 2207
Answers (1)
plor
Reputation: 282
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.
Upvotes: 2
Related Questions
- Converting java.time.LocalTime to java.sql.Time
- How to convert string timestamp into timestamp with a specific timezone
- Convert java.sql.Timestamp to Java 8 ZonedDateTime?
- Best way to Change java.sql.TimeStamp to UTC format in Java
- Covert UTC Date String to SQL Timestamp using Java 8
- Convert UTC java.sql.Time to java.time.localtime with correct DST
- Convert java.sql.Timestamp to java.sql.Timestamp in another timezone
- java.sql.Timestamp: changing timezone of Timestamp
- how do i fetch date timestamp as UTC
- Convert java.sql.Timestamp to local timezone