Re: Feeling some serious timezone pain

2014-08-21 Thread Subodh Nijsure
You could consider passing the timestamp in UTC to the template and then convert it to browser's timezone using javascript function - convertUTCDateToLocalDate(data)? -Subodh On Wed, Aug 20, 2014 at 5:22 AM, christophw wrote: > Hi there, > > I'm feeling some pain while wrangling with timezones i

Re: Feeling some serious timezone pain

2014-08-21 Thread Tom Evans
On Wed, Aug 20, 2014 at 1:22 PM, christophw wrote: > Hi there, > > I'm feeling some pain while wrangling with timezones in an office room > booking application. I'm storing bookings in a MySQL database and want to > display them in the timezone local to the office room, so it is not > necessarily

Re: Feeling some serious timezone pain

2014-08-21 Thread Geoffrey S. Knauth
Could there be something in or running the template that has a DST (daylight savings time) value turned off? -- Geoffrey S. Knauth | http://knauth.org/gsk On Thu, Aug 21, 2014, at 07:46, Erik Cederstrand wrote: > Den 21/08/2014 kl. 00.09 skrev Chris Whiten : > > > I can understand that sentiment

Re: Feeling some serious timezone pain

2014-08-21 Thread Erik Cederstrand
Den 21/08/2014 kl. 00.09 skrev Chris Whiten : > I can understand that sentiment... But that doesn't change the fact that > 12:00 PM on the Python side renders as 11 AM in the template, right? Your database stores the datetime as (the equivalent of) 16:00 UTC, right? Which is expected, because y

Re: Feeling some serious timezone pain

2014-08-20 Thread Chris Whiten
I can understand that sentiment... But that doesn't change the fact that 12:00 PM on the Python side renders as 11 AM in the template, right? On Wednesday, 20 August 2014 09:09:24 UTC-4, Erik Cederstrand wrote: > > > Den 20/08/2014 kl. 14.22 skrev christophw >: > > > When the booking is stored,

Re: Feeling some serious timezone pain

2014-08-20 Thread Erik Cederstrand
Den 20/08/2014 kl. 14.22 skrev christophw : > When the booking is stored, it comes back from a post and I store it in the > DB as such: > > dt = datetime.datetime.strptime(request.POST["date"] + " " + > request.POST["time"], "%Y-%m-%d %H:%M") > dt = pytz.timezone("America/Toronto").localize(dt

Re: Feeling some serious timezone pain

2014-08-20 Thread Chris Whiten
That's exactly right, but what's rendered in the browser is 11 AM rather than 12:00 On Wednesday, 20 August 2014 08:36:58 UTC-4, Geoffrey Knauth wrote: > > 2014-08-30 16:00:00+00:00 GMT > 2014-08-30 12:00:00-04:00 Toronto (Summer) > > This looks correct to me. Maybe you were expecting the timezo

Re: Feeling some serious timezone pain

2014-08-20 Thread Robin
Guys The UK is currently on British Summer Time (BST) so 2014-08-30 16:00:00 BST 2014-08-30 11:00:00 Toronto (Summer) Greenwich Mean Time (GMT) as a term is not used as frequently as previously. The preferred term is Universal Coordinated Time (UTC), as some overseas users confusingly equate G

Re: Feeling some serious timezone pain

2014-08-20 Thread Geoffrey S. Knauth
2014-08-30 16:00:00+00:00 GMT 2014-08-30 12:00:00-04:00 Toronto (Summer) This looks correct to me. Maybe you were expecting the timezone to be -05:00? That would be standard time (winter). Daylight savings time is -04:00. -- Geoffrey S. Knauth | [1]http://knauth.org/gsk On Wed, Aug 20, 2014,

Feeling some serious timezone pain

2014-08-20 Thread christophw
Hi there, I'm feeling some pain while wrangling with timezones in an office room booking application. I'm storing bookings in a MySQL database and want to display them in the timezone local to the office room, so it is not necessarily local to the user's local machine timezone. Here is my m