Re: Changing Date Format in RMAN log file
- From: Andy Rivenes <arivenes@xxxxxxxx>
- To: sbootsma@xxxxxxxxxxxxxx,<oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 23 Jan 2007 14:53:21 -0800
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@xxxxxxxx
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.
Other related posts:
