Yeah, I went through this myself a couple of weeks ago. Your best bet is to
store your dates like this,
YYYY-MM-DD HH:MM:SS. The data adapter for .NET we are shipping over here
allows you to write code for any other database via a data adapter, then
port your code with few to no changes. We have found that if you use your
dates in the above format, you will be good. This is the ANSI standard.
Something that I wish was documented was doing selects with this new cool
date routines. Here is an example that will depict enough to get busy with
sqlite and dates.
CREATE TABLE Allan (DateTimeField DateTime);
INSERT INTO Allan (DateTimeField) VALUES ('2004-01-04 12:00:00');
SELECT DateTimeField FROM Allan WHERE datetime(DateTimeField) =
datetime('2004-01-04 12:00:00');
SELECT DateTimeField FROM Allan WHERE datetime(DateTimeField) >
datetime('2004-01-03 12:00:00');
SELECT DateTimeField FROM Allan WHERE datetime(DateTimeField) <
datetime('2004-01-03 12:00:00');
The above selects appeared to be happy in a working system.
Thanks,
Allan
-----Original Message-----
From: Roger Reghin [mailto:[EMAIL PROTECTED]
Sent: Monday, January 05, 2004 6:07 AM
To: Ralph Wetzel
Cc: [EMAIL PROTECTED]
Subject: Re: [sqlite] Documentation
Thank you so much!! =)
Do you know anything about the DATE functions?
[]'s
Roger.
----- Original Message -----
From: "Ralph Wetzel" <[EMAIL PROTECTED]>
To: "Roger Reghin" <[EMAIL PROTECTED]>
Sent: Monday, January 05, 2004 8:04 AM
Subject: Re: [sqlite] Documentation
> Good Morning!
>
> > Also, I heard somebody also saying something about
"sqlite_encode_binary",
> > but couldn't find anything about that as well...
>
> The FAQ, Question 12, talks about BLOBs and the use of
> "sqlite_encode_binary". The function itself can be found in "encode.c",
that
> is, as stated before, not in the windows .zip distribution, but in the
full
> source tree and well documented there.
>
>
> Greetings, Ralph
>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
