SQLiteJDBC is just calling sqlite code for this functionality. http://www.sqlite.org/cvstrac/wiki?p=DateAndTimeFunctions
This is probably a question for the SQLite mailing list. http://www.sqlite.org/support.html --- Lapo Luchini <[EMAIL PROTECTED]> wrote: > 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... ____________________________________________________________________________________ Luggage? GPS? Comic books? Check out fitting gifts for grads at Yahoo! Search http://search.yahoo.com/search?fr=oni_on_mail&p=graduation+gifts&cs=bz --~--~---------~--~----~------------~-------~--~----~ Mailing List: http://groups.google.com/group/sqlitejdbc?hl=en To unsubscribe, send email to [EMAIL PROTECTED] -~----------~----~----~----~------~----~------~--~---
