SQLite: Insert current timestamp with milliseconds precision

Question

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?

Answer 1

Date and time functions reference says datetime(timestring, [modifiers...]) is equivalent to strftime('%Y-%m-%d %H:%M:%S', timestring, [modifiers...]).

If you want fractional seconds you must use %f not %S. So use strftime('%Y-%m-%d %H:%M:%f', 'now').