How to change nls date format for the database.? Below command does not workalter system set NLS_DATE_FORMAT = 'MM/DD/YYYY'; Regards,rupeshOracle LazyDBA home page