Simon Slavin wrote: > If you supply "default CURRENT_TIMESTAMP" I would expect SQLite to > evaluate CURRENT_TIMESTAMP, find a string value like > '2019-05-17 12:10:43', and store that string in the schema.
This keyword behaves magically. ANSI SQL-92 says: | The default value inserted in the column descriptor ... is as | follows: | Case: | a) If the <default clause> contains NULL, then the null value. | b) If the <default clause> contains a <literal>, then | Case: | i) If the subject data type is numeric, then the numeric value | of the <literal>. | [...] | d) If the <default clause> contains a <datetime value function>, | then the value of an implicit reference to the <datetime | value function>. Regards, Clemens _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
