PHP Timezone database is corrupt error
This issue can also occur when using php-fpm in chroot mode, the solution in this case to be to create something like /usr/share/zoneinfo/Europe in your chroot dir then copy your TZ file in to it e.g. London
timezone
How to make a datetime object aware (not naive)
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
Why is subtracting these two epoch-milli Times (in year 1927) giving a strange result?
It’s a time zone change on December 31st in Shanghai. See this page for details of 1927 in Shanghai. Basically at midnight at the end of 1927, the clocks went back 5 minutes and 52 seconds. So “1927-12-31 23:54:08” actually happened twice, and it looks like Java is parsing it as the later possible instant … Read more
How to detect Ambiguous and Invalid DateTime in PHP?
I ‘m not aware of any existing implementations and I haven’t had cause to use advanced date/time features such as these as yet, so here is a clean room implementation. To enable the syntax illustrated in the question we are going to extend DateTimeZone as follows: class DateTimeZoneEx extends DateTimeZone { const MAX_DST_SHIFT = 7200; … Read more
Get timezone by Country and Region
Finally, after long research, I’ve found the solution. It may not be much accurate, but it does not require the dependency of remote service. I’ve found that maxmind’s database provides mapping file between regions and time zones from Olsen database (aka tz database): http://www.maxmind.com/timezone.txt The second step was to convert Olsen timezones in .NET timezones. … Read more
Location based Timezone Retrieval
This depends on information the “location” contains? You’d somehow need to map the location to a timezone name, preferably the Olson style timezone names, because they are more detailed and easier to map, as they are locations themselves. If it’s an approximate addres (like country and city or so) then several geolocation services do include … Read more
Why doesn’t pytz localize() produce a datetime object with tzinfo matching the tz object that localized it?
They are the same time zone – “Europe/Berlin”. When you are printing them, the output includes the abbreviation and offset that applies at that particular point in time. If you examine the tz data sources, you’ll see: # Zone NAME GMTOFF RULES FORMAT [UNTIL] Zone Europe/Berlin 0:53:28 – LMT 1893 Apr 1:00 C-Eur CE%sT 1945 … Read more
Subtract hours from the now() function
Answer for timestamp You need to understand the nature of the data types timestamp (timestamp without time zone) and timestamptz (timestamp with time zone). If you don’t, read this first: Ignoring time zones altogether in Rails and PostgreSQL The AT TIME ZONE construct transforms a timestamp to timestamptz, which is almost certainly the wrong move … Read more
Does ConvertTimeFromUtc() and ToUniversalTime() handle DST?
Yes. ConvertTimeFromUtc will automatically handle daylight saving time adjustments, as long as the time zone that you are targeting uses daylight saving time. From the MSDN documentation: When performing the conversion, the ConvertTimeFromUtc method applies any adjustment rules in effect in the destinationTimeZone time zone. You should not try to add an additional hour in … Read more
NSDateFormatter and Time Zone issue?
If the date string is in GMT you can’t use your system Timezone to create the NSDate from the NSString. replace the first occurrence of [dateFormat setTimeZone:[NSTimeZone systemTimeZone]]; with [dateFormat setTimeZone:[NSTimeZone timeZoneWithName:@”GMT”]];