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]
-----------------------------------------------------------------------------

Reply via email to