Its an insert and my insert SQL contains the column timestamp and value nil.Will it work if the SQL contains timestamp through value is nil
If you explicitly specify NULL for the value of the column then there is no need for the system to produce a default, and thus you will see NULL when you query that record.
You can say “DEFAULT” (no quotes) though if you need to have the column name in the Insert statement but still want the default to be used.
David J.
