Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

how to remove padded space in date format

686951Oct 9 2009 — edited Oct 9 2009
Hi

I want to display date in DD Month YYYY format so I used to_char(dt,'DD Month YYYY') format but here month is padded with some extra space. Any idea to get date format without padded space?

Thanks,
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 6 2009
Added on Oct 9 2009
4 comments
4,993 views