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

Reply via email to