Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: date function

Re: date function

From: Martin Meyer <mmeyer_at_rhso.de>
Date: 1998/11/05
Message-ID: <364157B3.1C2AA3AA@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 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US