Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Date Function
Hi,
try :
select SYSDATE from dual
or
select to_char(SYSDATE,'YYYY/MM/DD HH24:MI:SS') from dual
You can use SYSDATE directly on PL/SQL
Regards. Olivier
RGS wrote:
> May someone please post the function that returns the system date.
>
> Thank you.
Received on Wed Mar 18 1998 - 00:00:00 CST