sqlite> select fmn,DATE('NOW'),supplierDate,date('now'),strftime(supplierDate),s
trftime(supplierDate)-date('now') from t93c_adl where strftime(supplierDate)<dat
e('now') limit 10;
854954|2012-11-09|12/01/2012|2012-11-09|12/01/2012|-2000
854952|2012-11-09|03/01/2013|2012-11-09|03/01/2013|-2009
635604|2012-11-09|05/27/2011|2012-11-09|05/27/2011|-2007
635605|2012-11-09|03/16/2012|2012-11-09|03/16/2012|-2009
635607|2012-11-09|09/15/2012|2012-11-09|09/15/2012|-2003
854944|2012-11-09|11/15/2012|2012-11-09|11/15/2012|-2001
636277|2012-11-09|05/01/2011|2012-11-09|05/01/2011|-2007
636278|2012-11-09|09/15/2011|2012-11-09|09/15/2011|-2003
636279|2012-11-09|10/01/2012|2012-11-09|10/01/2012|-2002
778450|2012-11-09|03/15/2012|2012-11-09|03/15/2012|-2009
sqlite>
why use supplierDate,date('now'),strftime(supplierDate) the result is not same
result format?
the one is 2012-11-09
another is 12/01/2012
?
and how to get the subtraction of two column?
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
