SQLite 3.8

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

CREATE TABLE ChangeLog (t INT, rowid INT, field TEXT , value TEXT)
    INSERT INTO ChangeLog (t, rowid, field, value)
    SELECT ":1", ":2", ":3", CAST((julianday('now') - 2440587.5)*86400000  AS INTEGER)
    FROM (VALUES
    (1, 1, 'field1', 1),
    (2, 1, 'field2', 1),
    (3, 1, 'field3', 1) ) sub;
SELECT * FROM CHangeLog


t
rowid
field
value


1
field1
1
1567878232290

1
field2
1
1567878232290

1
field3
1
1567878232290

t	rowid	field	value
1	field1	1	1567878232290
1	field2	1	1567878232290
1	field3	1	1567878232290