On Sun, 9 Apr 2006, ThomasChust wrote:
[...] is there an elegant way to make the current julian day number the default value for a column in SQLite3? [...]
Hello, sorry for the last post -- I figured out how it works myself: CREATE TABLE time(time REAL DEFAULT (julianday(current_timestamp)));I just didn't think about putting an additional pair of parentheses around the DEFAULT value, because it's normally not necessary.
cu, Thomas
