Re: insert timestamp upon insert?

[Mike Matrigali]

you probably can use an insert trigger to get the desired result.

Michael McCutcheon wrote:

Suppose I have a table like this:

CREATE TABLE discussion_thread
(

discussion_thread_id INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY (START WITH 1, INCREMENT BY 1),

   title                  VARCHAR(50) NOT NULL,
   creation_date          TIMESTAMP   NOT NULL,
   creator_user_id        VARCHAR(32) NOT NULL
);

Is there a way to have derby automatically populate the creation_date column with the current date/time upon insert?

Mike