Re: [sqlite] about date question

YAN HONG YE wrote: > sqlite> select > fmn,DATE('NOW'),supplierDate,date('now'),strftime(supplierDate),s > trftime(supplierDate)-date('now') from t93c_adl where > strftime(supplierDate) e('now') limit 10; > 854954|2012-11-09|12/01/2012|2012-11-09|12/01/2012|-2000 > > why

Re: [sqlite] about date question

Quoth YAN HONG YE , on 2012-11-09 08:35:25 +: > > > //--why have noting in the result?

Re: [sqlite] about date question

Quoth YAN HONG YE , on 2012-11-09 08:28:53 +: > The result let crazy. Because they're STRINGS! There is NO DATE TYPE in SQLite! Not to mention if those values are intended to be ISO 8601, they should have zero padding; it should be "2012-09-07" and such---in which case

[sqlite] about date question

sqlite> select strftime(importdate) from t93c_adl3 limit 5; 2012-9-13 2012-9-5 2012-10-9 2012-10-9 2012-10-9 sqlite> select strftime('%y-%m-%d',importdate) from t93c_adl3 limit 5;

[sqlite] about date question

The result let crazy. sqlite> select distinct importdate from t93c_adl3 order by importdate desc limit 12; 2012-9-7 2012-9-6 2012-9-5 2012-9-4 2012-9-3 2012-9-29 //---here , why? 2012-9-28 2012-9-27 2012-9-26 2012-9-25 2012-9-24 2012-9-20 sqlite>

Re: [sqlite] about date question

Quoth YAN HONG YE , on 2012-11-09 05:45:06 +: > 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 calendar functions

[sqlite] about date question

sqlite> select fmn,DATE('NOW'),supplierDate,date('now'),strftime(supplierDate),s trftime(supplierDate)-date('now') from t93c_adl where strftime(supplierDate) 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

[sqlite] about date question

the table had a column: SupplierDate Date I wanna add 84 days : SELECT SupplierDate+84 as date1 FROM ADL; BUT result have noting ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users