On 7 November 2012 09:42, YAN HONG YE <yanhong...@mpsa.com> 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 > -4713-12-01 >
select date( supplierDate, '+2 days' ) http://www.sqlite.org/lang_datefunc.html Regards. Simon _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
