DRH wrote
>> The date and time functions ... are fully tested ...
I'm using SQLite version 2.8.8, precompiled binaries, on Linux.
The date/time functions seem to work, but some of the modifiers
don't. Specifically, 'gregorian', 'julian', 'start of week',
'localtime', and 'utc' all cause the functions to return NULL;
also 'N months' and 'N years' zero the time (maybe that's
intentional).
Here are some examples cut and pasted from an interactive
session:
SELECT julianday('1066-10-14','gregorian');
<null>
sqlite> select datetime('now', 'start of week');
<null>
sqlite> select datetime('now', 'localtime');
<null>
sqlite> select datetime('2004-01-05 00:00:00', 'localtime');
<null>
sqlite> select datetime(2453010, 'localtime');
<null>
sqlite> select datetime(2453010);
2004-01-05 12:00:00
sqlite> select datetime('now', '20 minutes');
2004-01-05 15:41:02
sqlite> select datetime('now', '2 months');
2004-03-05 00:00:00
I wouldn't call these failures bugs, since the routines are
experimental, but I'll write a ticket if you want me to.
Regards
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
