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

_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to