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