db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Michael McCutcheon <michaelm...@frontiernet.net>
Subject insert timestamp upon insert?
Date Thu, 01 Dec 2005 05:28:29 GMT
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


Mime
View raw message