Hi 2011/4/22 Fabio Spadaro <fabiolinos...@gmail.com>
> Hi. > > > 2011/4/22 Pavel Ivanov <paiva...@gmail.com> > >> >> 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 >> > > from sqlite3 import * > ... > a = gestdb.cur.execute('''create table tipo (d date default > CURRENT_DATE''') > >>> > warning near "CURRENT_DATE": syntax error > -- > Fabio Spadaro > www.fabiospadaro.com > Sorry. I messed up the placement of quote. Work. -- Fabio Spadaro www.fabiospadaro.com _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
