> In my system is set up with 11:35:07 while I am in the data 9:37:30 > Why?
http://www.sqlite.org/lang_createtable.html "If the default value of a column is CURRENT_TIME, CURRENT_DATE or CURRENT_TIMESTAMP, then the value used in the new row is a text representation of the current UTC date and/or time." It won't be your local time. Pavel On Fri, Apr 22, 2011 at 5:46 AM, Fabio Spadaro <fabiolinos...@gmail.com> wrote: > 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 > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
