>> 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 <[email protected]> wrote: > Hi. > > 2011/4/21 Pavel Ivanov <[email protected]> > >> > 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 <[email protected]> >> wrote: >> > Hi. >> > >> > 2011/4/21 Black, Michael (IS) <[email protected]> >> > >> >> 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: [email protected] [[email protected]] >> on >> >> behalf of Fabio Spadaro [[email protected]] >> >> 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 >> >> [email protected] >> >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >> >> _______________________________________________ >> >> sqlite-users mailing list >> >> [email protected] >> >> 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 >> > [email protected] >> > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >> > >> ____________________________________________ >> sqlite-users mailing list >> [email protected] >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >> > > [(u'3.5.9',)] > > > -- > Fabio Spadaro > www.fabiospadaro.com > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
