db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mike Matrigali <mikem_...@sbcglobal.net>
Subject Re: insert timestamp upon insert?
Date Thu, 01 Dec 2005 17:39:47 GMT
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
> 
> 
> 


Mime
View raw message