`modified DATETIME AS (datetime(julianday())) STORED` Note that this will not work in versions of SQLite3 3.35.2 and later as the datetime functions that return 'now' (datetime(), julianday(), strftime(format), current date, current time, current_timestamp) are no longer permitted in computed columns. You now must use triggers to achieve the same effect. Also, there is no such datatype as `DATETIME`, `BOOLEAN` or `BIGINT` and that they will be NUMERIC, NUMERIC, and INTEGER respectively.