Re: date function

From: Martin Meyer <mmeyer_at_rhso.de>
Date: 1998/11/05
Message-ID: <364157B3.1C2AA3AA_at_rhso.de>#1/1

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.

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
  Received on Thu Nov 05 1998 - 00:00:00 CET