Re: Changing Date Format in RMAN log file

Try formatting your command like this:

sql 'ALTER SESSION SET NLS_DATE_FORMAT="DD-MON-YY HH24:MI"';

Note the double quotes for the date format and the single quotes around the SQL command. Just change the format to what you want.

P.S. Tim's advise should work as well.

Andy Rivenes
arivenes_at_llnl.gov

At 12:38 PM 1/23/2007, Sam Bootsma wrote:
>I call my RMAN script from a Unix shell script. I have pasted parts of
>the RMAN output below. Note that I have changed nls_date_format to
>'yyyy-mm-dd-hh24-mi-ss'. I expected to see the date displayed in this
>format, but instead I see the date as "23-JAN-07". Can anybody tell me
>how I can get the RMAN log file to show the date as
>2007-01-23-13-27-14? Or even better, as 2007-01-23 13:27:14.
>

--
http://www.freelists.org/webpage/oracle-l