Re: how to delete leading zero from date

rmartes wrote:
>
> I want to delete leading zero from date after converting into to_char
> format. etc. 06/25/2001 to 6/25/2001.
>
> thanks

Try this:
select to_char(sysdate,'fmMM/DD/RRRR') from dual 6/26/2001

-- 
____________________________________________________________
Jaroslaw Palka <jarek_at_kamsoft.com.pl> P.I.KAMSOFT, Katowice
tel. (+48 32) 209-07-05, fax 209-07-15    POLAND