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 _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
