Re: Current Date under Oracle

> 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?
>

With your syntax never

try that

insert into test (testdate) values (SYSDATE);

--
Regards
Nicolas Bronke Received on Thu Feb 03 2000 - 09:56:51 CST