Re: [sqlite] Date Comparison

[Paolo Vernazza]

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