Hi,
With regard to these new date/time functions as pointed out at:
http://www.sqlite.org/cvstrac/wiki?p=DateAndTimeFunctions
I have one question: I can't seem to be able to use them on actual datetime field in
the database. For instance, my test script as below:
create table test(a int, b
Eugene,
create table test(a int, b datetime);
insert into test values(1,'2004/1/3');
select * from test where date(b)='2004/1/3'
The SELECT statement returns no record.
But this works:
sqlite select * from test where b='2004/1/3';
1|2004/1/3
The date is not encoded properly in the
On Fri, 2 Jan 2004, KL Chin wrote:
Can anyone help on this problem, why with the query below
DELETE FROM ABC WHERE datein '12/29/03';
All my record date from '1/1/04' to '1/6/04' were delete.
Where datein was date type.
SQLite is typeless, see: http://www.sqlite.org/datatypes.html,
database.
Regards
KL Chin
-Original Message-
From: Michael A. Cleverly [SMTP:[EMAIL PROTECTED]
Sent: Friday, January 02, 2004 9:55 AM
To: KL Chin
Cc: '[EMAIL PROTECTED]'
Subject:Re: [sqlite] Date problem
On Fri, 2 Jan 2004, KL Chin wrote:
Can anyone help on this problem
CvtDate was currently use to reconstruct the SQL statement b4
insert into SQLite.
Thx in advanced.
Regards
KL Chin
-Original Message-
From: D. Richard Hipp [SMTP:[EMAIL PROTECTED]
Sent: Friday, January 02, 2004 11:38 AM
Cc: '[EMAIL PROTECTED]'
Subject:Re: [sqlite] Date