[sqlite] how to do select by Date and Time range?

[jack wu]

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.