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

Re: Current Date under Oracle

From: José Antonio Morcillo Valenciano <jamv_at_gtt.es>
Date: Fri, 04 Feb 2000 08:48:30 +0100
Message-ID: <389A844E.5ADFF1B0@gtt.es>


here we're!

insert into test values (sysdate);

Dirk Poppke wrote:

> 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 Fri Feb 04 2000 - 01:48:30 CST

Original text of this message

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