> 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 <fabiolinos...@gmail.com> wrote: > 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 > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
