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
Doug Van Horn wrote:
>
> Hi,
>
> I'm running into a problem with the database library in Django running
> against SQLite. I'm trying to understand why the following happens:
>
> $ sqlite3 date_test
> SQLite version 3.4.2
> Enter ".help" for instructions
> sqlite> create table foo (d date
Hi Doug,
You're not storing the dates as anything other than plain text, so the
short value:
'2008-01-01'
is lexigraphically "less than" your lower bound string of:
'2008-01-01 00:00:00'
and so falls outside the range of your "BETWEEN" select.
If you want to keep treating the strings as
Hi Doug,
I'm guessing that you expect your inserted values to be treated as a date.
BUT
sqlite> create table foo( d date null );
sqlite> insert into foo(d) values( '2008-01-01' );
sqlite> select d, typeof(d) from foo;
2008-01-01|text
http://www.sqlite.org/cvstrac/wiki?p=DateAndTimeFunctions may
My guess is that string comparison is taking place, and so "2008-01-01" is
less than "2008-01-01 00:00:00".
HTH,
Igor
-Original Message-
From: Doug Van Horn [mailto:[EMAIL PROTECTED]
Sent: Thursday, December 06, 2007 5:48 PM
To: sqlite-users@sqlite.org
Subject: [sqlite] Querying DATE
On Dec 6, 2007, at 9:48 PM, Doug Van Horn wrote:
Hi,
I'm running into a problem with the database library in Django running
against SQLite. I'm trying to understand why the following happens:
$ sqlite3 date_test
SQLite version 3.4.2
Enter ".help" for instructions
sqlite> create table foo
6 matches
Mail list logo