How do you change an American Date formart like: TO_DATE('03/06/1905 00:00:00', 'MM/DD/YYYY HH24:MI:SS')
To an Oracle UK date format i.e. 06-MAR-1903?
If you want to change for the whole production Database use the query below:
Go into SQL PLUS and type: Alter Database SET NLS_DATE_FORMAT = "Value that you want to set."
If you want the effect for just one user type the query below:
Alter Session SET NLS_DATE_FORMAT = "Value that you want to set." login.sql (for single user)