Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: how to delete leading zero from date
You can use ltrim:
select ltrim(to_char(...),'0') ...
-- Have a nice day Michel "rmartes" <rmartes_at_msn.com> a écrit dans le message news: uwiHGRe$AHA.55_at_cpmsnbbsa07...Received on Tue Jun 26 2001 - 01:48:40 CDT
> I want to delete leading zero from date after converting into to_char
> format. etc. 06/25/2001 to 6/25/2001.
>
> thanks
>
>