Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Date Function

Re: Date Function

From: Olivier Bercovitz <oberco_at_club-internet.fr>
Date: 1998/03/18
Message-ID: <3510391A.8A3A5881@club-internet.fr>#1/1

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

Original text of this message

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