>> What does "SELECT sqlite_version()" gives you in python with sqlite3 >> module? > [(u'3.5.9',)]
Well, CURRENT_DATE should work then, it was added in 3.1.0. Could you show us an exact statement you are trying to execute and the exact text of error you get? Pavel On Thu, Apr 21, 2011 at 1:43 PM, Fabio Spadaro <fabiolinos...@gmail.com> wrote: > Hi. > > 2011/4/21 Pavel Ivanov <paiva...@gmail.com> > >> > Does not work on python with sqlite3 module >> >> What does "SELECT sqlite_version()" gives you in python with sqlite3 >> module? >> >> >> Pavel >> >> >> On Thu, Apr 21, 2011 at 9:17 AM, Fabio Spadaro <fabiolinos...@gmail.com> >> wrote: >> > Hi. >> > >> > 2011/4/21 Black, Michael (IS) <michael.bla...@ngc.com> >> > >> >> create table t (d default CURRENT_DATE,i number); >> >> insert into t (i) values(1); >> >> select * from t; >> >> 2011-04-21|1 >> >> >> >> >> >> >> >> Use CURRENT_TIME if you want hours/minutes too. >> >> >> >> >> >> >> >> Michael D. Black >> >> >> >> Senior Scientist >> >> >> >> NG Information Systems >> >> >> >> Advanced Analytics Directorate >> >> >> >> >> >> >> >> ________________________________ >> >> From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] >> on >> >> behalf of Fabio Spadaro [fabiolinos...@gmail.com] >> >> Sent: Thursday, April 21, 2011 5:37 AM >> >> To: General Discussion of SQLite Database >> >> Subject: EXT :[sqlite] date field with default current date >> >> >> >> Hi. >> >> I'm working with python and sqlite3 and i ask how to create a table with >> a >> >> date >> >> field wih defaults current date. >> >> Thanks. >> >> -- >> >> Fabio Spadaro >> >> www.fabiospadaro.com<http://www.fabiospadaro.com/> >> >> _______________________________________________ >> >> sqlite-users mailing list >> >> sqlite-users@sqlite.org >> >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >> >> _______________________________________________ >> >> sqlite-users mailing list >> >> sqlite-users@sqlite.org >> >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >> >> >> > >> > Does not work on python with sqlite3 module >> > >> > -- >> > Fabio Spadaro >> > www.fabiospadaro.com >> > _______________________________________________ >> > sqlite-users mailing list >> > sqlite-users@sqlite.org >> > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >> > >> ____________________________________________ >> sqlite-users mailing list >> sqlite-users@sqlite.org >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >> > > [(u'3.5.9',)] > > > -- > Fabio Spadaro > www.fabiospadaro.com > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
