sqlite stores dates/times in floating point, the normal comparison operators should work fine on them. http://www.sqlite.org/cvstrac/wiki?p=DateAndTimeFunctions
On 7/4/05, jack wu <[EMAIL PROTECTED]> wrote: > > i have a table which has Date one the columns. i 'd > like run a query in this form: > > select * from table1 where Date>date1 and Date<date2; > > as we all understand sqlite does not have timestamp > datatype. i am wondering how everybody is working > around the limitation. thanks. > > jack. > -- Cory Nelson http://www.int64.org
