The Sqlite date/time routimes have a resolution to seconds, not
milliseconds. If you want milliseconds from SQL implement your own user
defined functions which give you milliseconds. You would access the
time functions using the API of the underlying OS.
You might choose to implement your underlying storage as a 64 bit integer.
Trey Mack wrote:
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]
-----------------------------------------------------------------------------
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
