SQLite 3.39

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE IF NOT EXISTS user (
  id INTEGER PRIMARY KEY, 
  insertTimestamp TEXT NOT NULL DEFAULT(strftime('%Y-%m-%d %H:%M:%f', 'now')) 
);
✓
INSERT INTO user DEFAULT VALUES;
✓
SELECT * FROM user;


id
insertTimestamp


1
2024-08-16 11:28:04.882