Re: date format question - Its in the book...

Gennady,

There's a whole section on formatting dates in Oracle in the book "Oracle8 Server SQL Reference", pgs 3-70 and following.

But, this is the short answer....

select to_char(sysdate, 'dd-MON-yy') from dual;

Gennady wrote:

> Hello.
> Could anybody give me a hint how to change
> date type data format from 4/20/99 12:50:54
> to 20-APR-99 (only date, no time)?
>
> Please, help
> Gennady
Received on Tue Apr 20 1999 - 17:21:44 CDT