It seems that sqlite3 does not support DATETIME data type. If I have the following data in table t1, how do I select people who is older than certain date?
create table t1(dob text, name text); insert into t1('11/12/1930', 'Larry'); insert into t1('2/23/2003', 'Mary'); select * from t1 where dob < '3/24/1950'; Thank you. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users