In general, to make a naive datetime timezone-aware, use the localize method: import datetime import pytz unaware = datetime.datetime(2011, 8, 15, 8, 15, 12, 0) aware = datetime.datetime(2011, 8, 15, 8, 15, 12, 0, pytz.UTC) now_aware = pytz.utc.localize(unaware) assert aware == now_aware For the UTC timezone, it is not really necessary to use localize since … Read more
Apparently, to get version 5.1.33 of MySQL JDBC driver to work with UTC time zone, one has to specify the serverTimezone explicitly in the connection string. jdbc:mysql://localhost/db?useUnicode=true&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=UTC
Here’s a simple helper function that will format JS dates for you. function toIsoString(date) { var tzo = -date.getTimezoneOffset(), dif = tzo >= 0 ? ‘+’ : ‘-‘, pad = function(num) { return (num < 10 ? ‘0’ : ”) + num; }; return date.getFullYear() + ‘-‘ + pad(date.getMonth() + 1) + ‘-‘ + pad(date.getDate()) … Read more
You can use the datetime object or their function aliases for this: Example (abridged from PHP Manual) date_default_timezone_set(‘Europe/London’); $datetime = new DateTime(‘2008-08-03 12:35:23’); echo $datetime->format(‘Y-m-d H:i:s’) . “\n”; $la_time = new DateTimeZone(‘America/Los_Angeles’); $datetime->setTimezone($la_time); echo $datetime->format(‘Y-m-d H:i:s’); Edit regarding comments but i cannt use this method because i need to show date in different time zones … Read more
java.time This was indeed a problem with java.util date-time API until JSR-310 was incorporated in Java SE 8. The java.util.Date object is not a real date-time object like the modern date-time types; rather, it represents the number of milliseconds since the standard base time known as “the epoch”, namely January 1, 1970, 00:00:00 GMT (or … Read more
AFAIK the time zone abbreviations are not recognized. However if you replace the abbreviation with the time zone offset, it will be OK. E.g.: DateTime dt1 = DateTime.ParseExact(“24-okt-08 21:09:06 CEST”.Replace(“CEST”, “+2”), “dd-MMM-yy HH:mm:ss z”, culture); DateTime dt2 = DateTime.ParseExact(“24-okt-08 21:09:06 CEST”.Replace(“CEST”, “+02”), “dd-MMM-yy HH:mm:ss zz”, culture); DateTime dt3 = DateTime.ParseExact(“24-okt-08 21:09:06 CEST”.Replace(“CEST”, “+02:00”), “dd-MMM-yy HH:mm:ss … Read more
Current Status: Starting with .NET 6, both forms of time zones are supported on any platform that has both time zone data and ICU installed, which is most installations of Windows, Linux, and MacOS. See Tobias’s answer. Original Answer: The primary source of the data for conversion between Windows and IANA time zone identifiers is … Read more
Use DateFormat. For example, SimpleDateFormat isoFormat = new SimpleDateFormat(“yyyy-MM-dd’T’HH:mm:ss”); isoFormat.setTimeZone(TimeZone.getTimeZone(“UTC”)); Date date = isoFormat.parse(“2010-05-23T09:01:02”);
If last_updated is a naive datetime object representing the time in UTC: from datetime import datetime, timedelta if (datetime.utcnow() – last_updated) > timedelta(hours=24): # more than 24 hours passed If last_updated is the local time (naive (timezone-unaware) datetime object): import time DAY = 86400 now = time.time() then = time.mktime(last_updated.timetuple()) if (now – then) > … Read more
using .setUTCHours() it would be possible to actually set dates in UTC-time, which would allow you to use UTC-times throughout the system. You cannot set it using UTC in the constructor though, unless you specify a date-string. Using new Date(Date.UTC(year, month, day, hour, minute, second)) you can create a Date-object from a specific UTC time.