Hi. 2011/4/22 Fabio Spadaro <[email protected]>
> Hi > > > 2011/4/22 Fabio Spadaro <[email protected]> > >> Hi. >> >> >> 2011/4/22 Pavel Ivanov <[email protected]> >> >>> >> 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 <[email protected]> >>> wrote: >>> > Hi. >>> > >>> > 2011/4/21 Pavel Ivanov <[email protected]> >>> > >>> >> > 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 >>> >> >>> > >>> > [(u'3.5.9',)] >>> > >>> > >>> > -- >>> > 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 >>> >> >> 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 [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
