dealing with “MySQL backend does not support timezone-aware datetimes”

Posted in python | Wednesday, December 30th, 2009 | No Comments » Trackback

When fetching events from an iCal feed and saving this into a database I got

MySQL backend does not support timezone-aware datetimes

This did the trick for me:

Install pytz (download here)

PLAIN TEXT
PYTHON:
  1. import pytz
  2. that_datetime_in_utc.astimezone(pytz.timezone('Europe/Zurich')).replace(tzinfo=None)

Caution: I don't really understand what I'm writing here - it feels like those posters in PHP forums who explain 'how to ...' and then trying to explain something they have no clue of, but well.. :-)

Leave a Reply