SQLite: Insert current timestamp with milliseconds precision

user_492336 0
Viewed 9630

I'm trying to insert the current timestamp into SQLite:

CREATE TABLE test (timestamp DATETIME);
INSERT INTO test VALUES(datetime('now'));

This does create the timestamp, but only with seconds-precision (the timestamp looks like 2013-12-17 07:02:20). Is it possible to add the milliseconds, as well?

sqlite sql
1 Answers
Related