select date( supplierDate, '+2 days' ) ;
use this cmd couldn't solve the problem;
will have nothing on this column:
sqlite> select fmn,'84 day'+supplierDate from t93c_adl where fmn like '85493%';
854939|95
854938|95
854937|95
sqlite> select fmn,date('84 day'+supplierDate) from t93c_adl where fmn like '854
93%';
854939|-4712-02-27
854938|-4712-02-27
854937|-4712-02-27
sqlite> select fmn,date(supplierDate) from t93c_adl where fmn like '85493%';
854939|
854938|
854937|
sqlite> select fmn,supplierDate from t93c_adl where fmn like '85493%';
854939|11/15/2012
854938|11/30/2012
854937|11/30/2012
sqlite> select fmn,date(supplierDate,'+2 days') from t93c_adl where fmn like '85
493%';
854939|
854938|
854937|
sqlite>
Message: 10
Date: Wed, 7 Nov 2012 10:48:24 +0000
From: Simon Davies <simon.james.dav...@gmail.com>
To: General Discussion of SQLite Database <sqlite-users@sqlite.org>
Subject: Re: [sqlite] FW: about date question
Message-ID:
<cang6ahschcfgybcfsyuf_btdfmry+g9k4auxrsnyni-4yr8...@mail.gmail.com>
Content-Type: text/plain; charset=ISO-8859-1
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
