Hi, The column in question has type timestamp yet this doesn't work:
ij> alter table <tablename> alter column <columnname> default current_timestamp; ERROR 22005: An attempt was made to get a data value of type 'long' from a data value of type 'TIMESTAMP'. The table does not have any rows. Amir