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 -> Current Date under Oracle

Current Date under Oracle

From: Dirk Poppke <poppke_at_iug.cs.uni-dortmund.de>
Date: Thu, 3 Feb 2000 16:08:29 +0100
Message-ID: <87c5ld$bot$1@fbi-news.cs.uni-dortmund.de>


Hello!

Stupid question:

The standard SQL - Statement won't work under Oracle:

create table test (testdate date);
insert into test values (CURRENT_DATE);

How can I get the current Date (and Time) and put it into a table?

Thanks,
Dirk Received on Thu Feb 03 2000 - 09:08:29 CST

Original text of this message

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