> 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
