How do I convert '03-apr-2001' to '3-apr-2001'

[rotem_fo]

Hi,
you can use alter session set NLS_DATE_FORMAT = 'D/MMM/YYYY' , but you'll lose all leading decimal number for dates like 14/03/2001, so what you have to do is convert the date type to varchar2 through PL/SQL and user substr;

ex:
select substr(to_char(sysdate),2) from dual;