Re: How to change date format in a PL/SQL block.

Jim Lyons wrote:
>
> Ruby Goel wrote:
> >
> > I want to set date format to "DD-MON-YYYY HH24:MI:SS" from
> > PL/SQL block. I can not use following (because PL/SQL does not
> > support ALTER statements)
>
> Why not just use to_char and to_date to use any sort of date format
> you want?
>
> --
> Jim Lyons | Operating Systems Specialist
> Computation Center | 512-475-9331
> University of Texas at Austin | j.lyons_at_cc.utexas.edu
> http://www.cc.utexas.edu/~godzilla/jimlyons.htmla little more useful, though I agree with Jim:

select to_char (sysdate, 'dd-mon-yyyy hh24:mi:ss') from dual; Received on Sun May 05 1996 - 00:00:00 CEST