SQLite received a naive datetime while time zone support is active

Question

I'm getting the following error while running my sql in python

/usr/lib/python2.6/site-packages/django/db/backends/mysql/base.py:64: RuntimeWarning: SQLite received a naive datetime (2012-06-22 15:53:43) while time zone support is active.

my query also returns the wrong data. if i change the time up 2 hours (17:53:43 instead of 15:53:43), my timezone atm is gmt +2 so i think the problem is in the time zone.

how do i change my query to make the sql execute in the way i intend it to?

sql:

sqlQuery = """SELECT w.id, w.serial, w.finishdate, w.weighingtype_id, w.netto, w.bruto, w.deleted
    FROM weighing w
    LEFT JOIN weighing w1
    ON w1.id = w.parent_id 
    WHERE w.user_id = %(userid)s"""
if date:
    sqlQuery = sqlQuery + " AND (w.created = %(date)s OR w.modified > %(date)s)"

edit: added my code for transforming the datetime

data = request.GET.copy()
if 'date' in data:
    try:
        data['date'] = datetime.datetime.strptime(data['date'], "%Y-%m-%dT%H:%M:%S")
    except:
        raise error(311)

Use UTC time in the code - time zone support is enabled and will handle it. — user1166147, Jun 22 '12 at 14:17
the error says it's an SQLite database, but it's an MySQL database — Arno_C, Jun 22 '12 at 14:36
Possible duplicate of [DateTimeField received a naive datetime](http://stackoverflow.com/questions/21038881/datetimefield-received-a-naive-datetime) — Paul Sweatte, Nov 21 '16 at 22:17

SQLite received a naive datetime while time zone support is active

0 Answers0