On 9 November 2012 02:42, YAN HONG YE <[email protected]> wrote: > sqlite> select > fmn,DATE('NOW'),supplierDate,julianday('now'),julianday(supplierDate),julianday('supplierDate') > from t93c_adl where supplierDate>julianday('now') limit 5 ; > 854954|2012-11-09|12/01/2012|2456240.61186149|| > 854952|2012-11-09|03/01/2013|2456240.61186149|| > 635604|2012-11-09|05/27/2011|2456240.61186149|| > 635605|2012-11-09|03/16/2012|2456240.61186149|| > 635607|2012-11-09|09/15/2012|2456240.61186149||
http://www.sqlite.org/lang_datefunc.html ISO-8601 format for date strings Regards, Simon _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
