Force Java timezone as GMT/UTC

by

The OP answered this question to change the default timezone for a single instance of a running JVM, set the user.timezone system property:

java -Duser.timezone=GMT ... <main-class>

If you need to set specific time zones when retrieving Date/Time/Timestamp objects from a database ResultSet, use the second form of the getXXX methods that takes a Calendar object:

Calendar tzCal = Calendar.getInstance(TimeZone.getTimeZone("GMT"));
ResultSet rs = ...;
while (rs.next()) {
    Date dateValue = rs.getDate("DateColumn", tzCal);
    // Other fields and calculations
}

Or, setting the date in a PreparedStatement:

Calendar tzCal = Calendar.getInstance(TimeZone.getTimeZone("GMT"));
PreparedStatement ps = conn.createPreparedStatement("update ...");
ps.setDate("DateColumn", dateValue, tzCal);
// Other assignments
ps.executeUpdate();

These will ensure that the value stored in the database is consistent when the database column does not keep timezone information.

The java.util.Date and java.sql.Date classes store the actual time (milliseconds) in UTC. To format these on output to another timezone, use SimpleDateFormat. You can also associate a timezone with the value using a Calendar object:

TimeZone tz = TimeZone.getTimeZone("<local-time-zone>");
//...
Date dateValue = rs.getDate("DateColumn");
Calendar calValue = Calendar.getInstance(tz);
calValue.setTime(dateValue);

Usefull Reference

https://docs.oracle.com/javase/9/troubleshoot/time-zone-settings-jre.htm#JSTGD377

https://confluence.atlassian.com/kb/setting-the-timezone-for-the-java-environment-841187402.html

More Related Contents:

  1. How can I get the current date and time in UTC or GMT in Java?
  2. How to get the day from timezone in java [duplicate]
  3. How to set time zone of a java.util.Date?
  4. Dates with no time or timezone component in Java/MySQL
  5. Timezone conversion
  6. Java SimpleDateFormat(“yyyy-MM-dd’T’HH:mm:ss’Z'”) gives timezone as IST
  7. How to use an Internet time server to get the time?
  8. SimpleDateFormat parsing date with ‘Z’ literal [duplicate]
  9. Date and time conversion to some other Timezone in java
  10. Any difference between java.time.Clock.systemDefaultZone().getZone() vs java.util.TimeZone.getDefault().toZoneId()?
  11. Is java.util.Date using TimeZone?
  12. How to get the current date and time of your timezone in Java?
  13. How to get TimeZone from android mobile?
  14. Understanding the Etc/GMT time zone
  15. Convert UTC into Local Time on Android
  16. Why does Java’s java.time.format.DateTimeFormatter#format(LocalDateTime) add a year?
  17. Timezones in SQL DATE vs java.sql.Date
  18. Java Time Zone is messed up
  19. What is the default timezone in java.util.Date
  20. Getting the current time millis from device and converting it into a new date with different timezone [duplicate]
  21. Difference between UTC and GMT Standard Time in .NET
  22. Convert UTC to current locale time
  23. Android get Current UTC time [duplicate]
  24. Difference between EST and America/New_York time zones
  25. Get TimeZone offset value from TimeZone without TimeZone name
  26. Java Time Zone When Parsing DateFormat
  27. Java: getTimeZone without returning a default value
  28. Java 8: Calculate difference between two ZonedDateTime
  29. TimeZones in Java
  30. Why is subtracting these two epoch-milli Times (in year 1927) giving a strange result?

Leave a Comment