-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 05/23/2011 08:46 AM, Fabio Spadaro wrote:
> Hi
When you quote other messages, only quote the relevant pieces that you are
replying to. Several hundred lines is not appropriate.
> What is the difference between "sqlite3.version" (typed on command
> I resolved with:
>CREATE TRIGGER insert_nameTable after insert on
>name_tabl begin
>update set ww = datetime('now','localtime')
>where rowid = new.rowid; end"
You don't have to fire a trigger for such default:
CREATE TABLE "test" (
"mydate" CHAR DEFAULT (date
>>>> >> >
> >>>> >> >> create table t (d default CURRENT_DATE,i number);
> >>>> >> >> insert into t (i) values(1);
> >>>> >> >> select * from t;
> >>>> >
CURRENT_DATE,i number);
>>>> >> >> insert into t (i) values(1);
>>>> >> >> select * from t;
>>>> >> >> 2011-04-21|1
>>>> >> >>
>>>> >> >>
>>>> >> >>
From: Fabio Spadaro
To: General Discussion of SQLite Database
Sent: Fri, April 22, 2011 12:46:53 PM
Subject: Re: [sqlite] date field with default current date
>In my system is set up with 11:35:07 while I am in the data 9:37:30
>Why?
What
ber);
>>> >> >> insert into t (i) values(1);
>>> >> >> select * from t;
>>> >> >> 2011-04-21|1
>>> >> >>
>>> >> >>
>>> >> >>
>>> >> >> Use CURRENT_TIME if
t; >>
>> >> >> Use CURRENT_TIME if you want hours/minutes too.
>> >> >>
>> >> >>
>> >> >>
>> >> >> Michael D. Black
>> >> >>
>> >> >> Senior Scientist
>> &
gt; >> >>
> >> >>
> >> >>
> >> >> Use CURRENT_TIME if you want hours/minutes too.
> >> >>
> >> >>
> >> >>
> >> >> Michael D. Black
> >> >>
> >> >> Senior
>>
>> >> Senior Scientist
>> >>
>> >> NG Information Systems
>> >>
>> >> Advanced Analytics Directorate
>> >>
>> >>
>> >>
>> >>
>> >> Fro
t;
> >> ________
> >> 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 Di
formation Systems
>>
>> Advanced Analytics Directorate
>>
>>
>>
>>
>> From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on
>> behalf of Fabio Spadaro [fabiolinos...@gmail.com]
>> Sent: Thursd
2011/4/21 Mihai Militaru
> On Thu, 21 Apr 2011 15:17:00 +0200
> Fabio Spadaro wrote:
>
> > Does not work on python with sqlite3 module
>
> Try using the date and time functions, 'date' or 'datetime' in your case:
> INSERT INTO table(..., date) VALUES(..., datetime('now'));
>
> http://www.sqlite.
On Thu, 21 Apr 2011 15:17:00 +0200
Fabio Spadaro wrote:
> Does not work on python with sqlite3 module
Try using the date and time functions, 'date' or 'datetime' in your case:
INSERT INTO table(..., date) VALUES(..., datetime('now'));
http://www.sqlite.org/lang_datefunc.html
--
Mihai Militaru
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 def
: 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 sq
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
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailma
16 matches
Mail list logo