Hello,is there an elegant way to make the current julian day number the default value for a column in SQLite3?
When I try to create a table like this CREATE TABLE time(time REAL DEFAULT julianday(current_timestamp));I get of course a syntax error, because the calling of functions in the DEFAULT value is apparently not allowed.
cu, Thomas