if you just want the output then use


to_char(date, dateformat)


so for 23/03/01

to_char('23-mar-2001', 'dd/mm/yy')

or for 230301

to_char('23-mar-2001', 'ddmmyy')


If you want to change the date format and don't want to convert the data type then you can do that in you machine by setting the

NLS_DATE_FORMAT parameter

or you can also change for a session

alter session set nls_date_format='dd/mm/yyyy';

or for the data base