YAN HONG YE <yanhong...@mpsa.com> wrote:
> 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
>
> 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
How are *we* supposed to know why you chose to put data in the wrong format
into *your* database?
> and how to get the subtraction of two column?
I'll tell you - *after* you change supplierDate column to a format that
date/time functions recognize. I showed you how.
--
Igor Tandetnik
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
