I did, but I always got a false from the comparison.
All dates are stored 'YYYY-mm-dd'
I had to end up doing this to make it work:
Where ( strftime("%Y%m%d",my_date_field)+0 ) > 20050501
-----Original Message-----
From: Paolo Vernazza [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 24, 2005 3:51 PM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] Date Comparison
John Buck wrote:
>If I have a table with a "date" column type.
>
>Is this valid in SqLite??
>
>Select * from MYTABLE where my_date_field > '2005-05-01';
>
If you saved the data in my_data_field as yyyy-mm-dd, the, yes, your
query is valid.
Paolo
