'between' will work fine with your situation, you just have to use
between '2008-01-01' and '2008-01-31 23:59:59.999999'
or even better
between '2008-01-01' and '2008-01-31Z'
HTH,
Sam
-------------------------------------------
We're Hiring! Seeking a passionate developer to join our team building Flex
based products. Position is in the Washington D.C. metro area. If interested
contact
careers@...
-----Original Message-----
From: Doug Van Horn [mailto:
dougvanhorn@...]
Sent: Thursday, December 06, 2007 10:30 AM
To:
sqlite-users@...
Subject: Re: [sqlite] Querying DATE column with date/time string.
Thanks Dan, Igor, Donald, and Simon!
It's a problem with the Django library (a Python web framework), where that
between clause is being used for several different databases. I'm going to
report back there with your (collective) explanation. I appreciate the
help!
-----------------------------------------------------------------------------
To unsubscribe, send email to
sqlite-users-unsubscribe@...
-----------------------------------------------------------------------------
