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