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
