Re: Current Date under Oracle

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Thu, 03 Feb 2000 20:11:38 +0800
Message-ID: <3899707A.3079@yahoo.com>

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

CURRENT_DATE is for PL/SQL, use SYSDATE for SQL.

HTH
--

---

Connor McDonald
"These views mine, no-one elses etc etc" connor_mcdonald_at_yahoo.com

"Some days you're the pigeon, and some days you're the statue." Received on Thu Feb 03 2000 - 06:11:38 CST