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

Reply via email to