subject:"\[sqlite\] FW\: about date question"

Re: [sqlite] FW: about date question

2012-11-07 Thread Simon Davies

On 7 November 2012 09:42, YAN HONG YE wrote: > the table had a column: SupplierDate Date > I wanna add 84 days : > SELECT SupplierDate+84 as date1 FROM ADL; > BUT result have noting > when use: > select date(supplierdate+'2 day') from t93c_adl limit 3; > the result is: > -4713-12-08 > -4713-11-29

[sqlite] FW: about date question

2012-11-07 Thread YAN HONG YE

the table had a column: SupplierDate Date I wanna add 84 days : SELECT SupplierDate+84 as date1 FROM ADL; BUT result have noting when use: select date(supplierdate+'2 day') from t93c_adl limit 3; the result is: -4713-12-08 -4713-11-29 -4713-12-01 ___ sq