I rather thought about retrieving and storing milliseconds in SQL. I
mean, a SQL data type which is able to store milliseconds and a SQL
function to return the current timestamp including milliseconds. I had
no luck with CURRENT_TIMESTAMP for instance.
There is no true SQLite DATE data type. It's either TEXT or REAL, depending
on how you choose to store your dates.
Is this what you're after?
SQLite version 3.4.0
Enter ".help" for instructions
sqlite> select strftime("%Y-%m-%d %H:%M:%f", "now");
2007-07-12 13:58:34.797
Info about date/time functions in SQLite can be found at
http://www.sqlite.org/cvstrac/wiki?p=DateAndTimeFunctions
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------