Understood!!
Now, let me ask you something else about this subject...
When comparing values, does SQLite transform the DateTime value to a string
before comparing?
For example, as Allan wrote:
SELECT DateTimeField FROM Allan WHERE datetime(DateTimeField) =
datetime('2004-01-04 12:00:00');
So, before comparing "datetime(DateTimeField) = datetime('2004-01-04
12:00:00')", does SQLite transform both to string and then do the compare,
or does it transform both to floating point and then compare them?
I ask that because I know there�s an overhead doing the typecast, so I would
like to choose what costs less, in my case.
Thanx!!
Roger.
----- Original Message -----
From: "D. Richard Hipp" <[EMAIL PROTECTED]>
To: "'SQLite Mailingliste'" <[EMAIL PROTECTED]>
Sent: Monday, January 05, 2004 11:37 AM
Subject: [sqlite] Date and Time functions are experimental
> Allan Edwards wrote:
> > I looked through the source code and those functions "WERE"
experimental.
> > They appear to be a full non experimental in the sqlite source code at
this
> > point. Thus far I have not found any problems with them. You can
#define
> > them out on a compilation if you don't want date routines, but they look
to
> > be fully integrated! : - )
> >
>
> The date and time functions are fully integrated, but they are also still
> "experimental". They are fully tested with 100% code coverage and will
probably
> work fine. But they are still "experimental".
>
> "Experimental" means that I reserve the right to change the API in an
> incompatible way in a future release. The date and time functions will
> stop being experimental once they are in the official documentation and
> we decide to support them in all future releases.
>
>
> --
> D. Richard Hipp -- [EMAIL PROTECTED] -- 704.948.4565
>
>
> ---------------------------------------------------------------------
> 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]
