Re: [sqlite] datetime question

boun...@sqlite.org] On Behalf Of YAN HONG YE > Sent: Wednesday, 22 August, 2012 20:14 > To: sqlite-users@sqlite.org > Subject: [sqlite] datetime question > > ___ > sqlite-users mailing list > sq

Re: [sqlite] datetime question

On 23 Aug 2012, at 3:14am, YAN HONG YE wrote: > create table test( Date datetime); > insert test now(); > select date+2 as bbb,date-12 as cc from test; > the result is > 2014,2000 > I wanna know how to add any day use sql command There is no field type 'datetime'. Dates

[sqlite] datetime question

create table test( Date datetime); insert test now(); select date+2 as bbb,date-12 as cc from test; the result is 2014,2000 I wanna know how to add any day use sql command ___ sqlite-users mailing list sqlite-users@sqlite.org