Python and SQL Server: Issue with datetime Data

Question

I have a SQL Server table that contains some datetime data. I'm using a Python script with pymssql to connect to the database and execute queries.

The problem I'm having is that when my queries return datetime data, the dates are shifted and are no longer accurate. For example, one data entry in my table is for the date '2012-03-27', but when I retrieve it and store it in my script as a datetime object in Python, the date is stored as '2012-01-03'.

Any ideas on how to fix this? Should I be using a library like pytz?

Thanks!

Answer 1

I am having the same issue with pymssql version 1.02. Although its not the cleanest aproach, I am using the workaround suggested by the OP and converting the string value to a python datetime object with the correct values using the dateutil.parser module. Here is the code I am using, provided that iso_datetime_string contains the string with the datetime in ISO format, as returned by the workaround:

import dateutil.parser as ps

correct_datetime_obj = ps.parse(iso_datetime_string)