Re: date function

From: Yakov Fradkin <yfradkin_at_eccms1.dearborn.ford.com>
Date: Thu, 05 Nov 1998 12:16:58 -0500
Message-ID: <3641DD8A.1AC53857_at_eccms1.dearborn.ford.com>

Martin Meyer wrote:
> Most comfortable is declaring the table as follows:> create table test

>(n number, d date DEFAULT SYSDATE);

> Then > insert into test (n) values (2);
> inserts a row with the current date in column d.

This does not cover "UPDATE". You still need to have a trigger...

>
> Martin.
>
> CB schrieb:
> >
> > I am trying to insert the "current date" into a column for each record
> > inserted or updated into a given table. Does anybody know if is amy
> > function in Oracle I can use for this task?
> >
> > cornel

Yakov Received on Thu Nov 05 1998 - 18:16:58 CET