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
