Sunday, January 26, 2014

Set Date format in RMAN


rman always shows date in DD-MON-YY format.

How to set date format to MM/DD/YYYY HH24:MI:SS in rman ? 

You can just set the NLS_DATE_FORMAT before going into RMAN: 

$ export NLS_DATE_FORMAT="dd-month-yyyy hh:mi:ss am"
$ rman target=/

No comments: