On 9 November 2012 01:40, YAN HONG YE <yanhong...@mpsa.com> wrote:
> 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
The dates you are trying to process are not ISO-8601 standard
The link provided earlier to the date and time functions indicate that
the textual date/time must conform to (a subset of) ISO-8601
Regards,
Simon
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
