On 28-Feb-2008, at 1:29 PM, Yong Zhao wrote: > 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?
Use YYYY-MM-DD instead of M/D/Y. Available formats described here under Time Strings: http://www.sqlite.org/cvstrac/wiki?p=DateAndTimeFunctions _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
