Re: How to change date format in a PL/SQL block.
From: Jim Lyons <godzilla_at_waldowoo.cc.utexas.edu>
Date: 1996/05/05
Message-ID: <4mi256$mdp_at_geraldo.cc.utexas.edu>#1/1
Date: 1996/05/05
Message-ID: <4mi256$mdp_at_geraldo.cc.utexas.edu>#1/1
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.htmlReceived on Sun May 05 1996 - 00:00:00 CEST