Thanks -- that makes sense. My error not considering that 00:00:00 might not exist on the first of the month.
Suggestion how best to do this? I'm running queries where I want to fetch rows with a timestamp within a given month -- but that time range should be in the time zone of the user I'm running the query for. In other words, I'm trying to find the start and end times for the current month based on a given timezone and then use those in my database query. On Fri, Apr 22, 2016 at 3:51 PM, Zefram <zef...@fysh.org> wrote: > Bill Moseley wrote: > >Why can't I truncate to the month? > > Because 2016-04-01T00:00:00 didn't exist in Asia/Amman. Its DST rules > include a switch from winter time to summer time at 24:00 on the last > Thursday in March. This has the effect of skipping the hour from 00:00 > to 01:00 on some Friday morning. This year the last Thursday in March was > the last day in March, so the affected Friday was the first day of April. > > -zefram > -- Bill Moseley mose...@hank.org
