"Yong Zhao" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > 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';
Store dates in YYYY-MM-DD format instead, then simple string comparison will also order dates correctly. Igor Tandetnik _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
