Oracle date query in django

Vote count:

0

This is the SQL I get from Django when making a date query on Oracle (i is an instance of Model.objects):

from datetime import datetime as dt
dates = [dt(2014,07,01), dt(2014,07,02)]
print i.filter(incd_date_d__range=dates).query

SELECT "SCHEMA"."TABLE"."COL1", "SCHEMA"."TABLE"."DATE_COL" 
FROM "SCHEMA"."TABLE" 
WHERE "SCHEMA"."TABLE"."DATE_COL" 
BETWEEN 2014-07-01 00:00:00 AND 2014-07-02 00:00:00

This returns a database error (ORA-01850: hour must be between 0 and 23). Notice how the dates are not surrounded by inverted commas. Is this intended behaviour?

asked 1 min ago

dmvianna

1,659

Oracle date query in django