On 5/24/05, John Buck <[EMAIL PROTECTED]> 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';
please read the docs. http://www.sqlite.org/cvstrac/wiki?p=DateAndTimeFunctions