'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 [EMAIL PROTECTED] -----Original Message----- From: Doug Van Horn [mailto:[EMAIL PROTECTED] Sent: Thursday, December 06, 2007 10:30 AM To: sqlite-users@sqlite.org 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 [EMAIL PROTECTED] -----------------------------------------------------------------------------
