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 dat
You won't find /MM/DD in the list of legal time strings.
By the way, the developer(s) intend for dates to be stored
as floats (in tables). Try
select date(2453007.5);
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For add
Kurt,
Thanks for your message.
>>date() returns NULL because you're giving it an illegal time string
Well, I thought the date (not the time) string I'm giving is correct, e.g. "2004/1/3'.
It is in the correct format "/MM/DD".
I am not interested in the DATE part, that is why I'm calling "da
There seem to be some problems with the date/time functions,
but your statements will never work. Your select returns
NULL because date() returns NULL. date() returns NULL
because you're giving it an illegal time string. Read the
docs again, and pay attention to the list of legal time
str
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 dat
t: Friday, January 02, 2004 11:38 AM
Cc: '[EMAIL PROTECTED]'
Subject:Re: [sqlite] Date problem
KL Chin wrote:
>
> Is that away to have a "DATE" comparison inside SQLite?
> Or any expression to convert DATE to integer in SQLite?
> I mean, I don;t ha
Hi D. Richard Hipp,
Thx for ur help.
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 problem
KL Chin wrote:
>
> Is that away
KL Chin wrote:
Is that away to have a "DATE" comparison inside SQLite?
Or any expression to convert DATE to integer in SQLite?
I mean, I don;t have to worry about data migration from other
database.
http://www.sqlite.org/cvstrac/wiki?p=DateAndTimeFunctions
--
D. Richard Hipp -- [EMAIL PROTECTED] -
from other
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:
>
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
10 matches
Mail list logo
