Good Day, Derby version: 10.2.2.0
As part of the database data upgrade process I need to do the following so that the existing rows get a NULL for the column but all new rows will get the default of the current timestamp. CREATE TABLE X ( FIELD INT ) ALTER TABLE X ADD COLUMN FIELD_DATE TIMESTAMP ALTER TABLE X ALTER FIELD_DATE DEFAULT CURRENT_TIMESTAMP Regards, Mark P Ashworth -- View this message in context: http://www.nabble.com/Alter-TIMESTAMP-field-default-after-creation-does-not-work-tp18650021p18650021.html Sent from the Apache Derby Users mailing list archive at Nabble.com.
