http://www.zentus.com/sqlitejdbc/usage.html
Shouldn't datetime(?, 'unixepoch') be changed to something more like
datetime(?/1000, 'unixepoch')?
Java uses "64-bit milliseconds since the epoch", not the usual "32-bit
seconds since the epoch"... and even if datetime(?, 'unixepoch') seems
to perfectly support bigger-than-32bit values, is also seems to
interpret them as seconds anyway.
In fact, having ticks ore precise than a second may be important, and
'unixepoch' maybe should be "extended" SQLite-side, but in that case I
guess a different name should be used, for backward compatibility. Of
course everyone can add his own self-defined function, but well, since
the funcionality is out there...
Lapo
--
Lapo Luchini
[EMAIL PROTECTED] (OpenPGP & X.509)
www.lapo.it (Jabber, ICQ, MSN)
--~--~---------~--~----~------------~-------~--~----~
Mailing List: http://groups.google.com/group/sqlitejdbc?hl=en
To unsubscribe, send email to [EMAIL PROTECTED]
-~----------~----~----~----~------~----~------~--~---
