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
