Hi. 2011/4/22 Fabio Spadaro <fabiolinos...@gmail.com>
> Hi > > > 2011/4/22 Fabio Spadaro <fabiolinos...@gmail.com> > >> Hi. >> >> >> 2011/4/22 Pavel Ivanov <paiva...@gmail.com> >> >>> >> What does "SELECT sqlite_version()" gives you in python with sqlite3 >>> >> module? >>> > [(u'3.5.9',)] >>> >>> Well, CURRENT_DATE should work then, it was added in 3.1.0. Could you >>> show us an exact statement you are trying to execute and the exact >>> text of error you get? >>> >>> >>> Pavel >>> >>> >>> On Thu, Apr 21, 2011 at 1:43 PM, Fabio Spadaro <fabiolinos...@gmail.com> >>> wrote: >>> > Hi. >>> > >>> > 2011/4/21 Pavel Ivanov <paiva...@gmail.com> >>> > >>> >> > 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 >>> >> >>> > >>> > [(u'3.5.9',)] >>> > >>> > >>> > -- >>> > 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 >>> >> >> from sqlite3 import * >> ... >> a = gestdb.cur.execute('''create table tipo (d date default >> CURRENT_DATE''') >> >>> >> warning near "CURRENT_DATE": syntax error >> -- >> Fabio Spadaro >> www.fabiospadaro.com >> > > Sorry. > I messed up the placement of quote. > Work. > > -- > Fabio Spadaro > www.fabiospadaro.com > I just set a table with "create table timest (test text, d timestamp default CURRENT_TIMESTAMP) " After i just make insert: "insert into timest (test) values ('tttt2') " I see these values: '(u'tttt2', datetime.datetime (2011,4, 22, 9, 37, 30) ' but the clock set up in my MS windows OS is set to different time. In my system is set up with 11:35:07 while I am in the data 9:37:30 Why? Thanks. -- Fabio Spadaro www.fabiospadaro.com _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users