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)
WITH cte(c1,c2,c3,c4) AS (
  VALUES (1, 1, 'field1', 1),
         (2, 1, 'field2', 1),
         (3, 1, 'field3', 1)
)
INSERT INTO ChangeLog (t, rowid, field, value)
SELECT c1,c2,c3, CAST((julianday('now') - 2440587.5)*86400000  AS INTEGER)
FROM cte;
SELECT * FROM CHangeLog


t
rowid
field
value


1
1
field1
1528438792505

2
1
field2
1528438792505

3
1
field3
1528438792505

t	rowid	field	value
1	1	field1	1528438792505
2	1	field2	1528438792505
3	1	field3	1528438792505