Re: Any was to format the Month to Display as 'Feb'?

fitzjarrell_at_cox.net says...
>
> CC wrote:
> > When selecting a data field and using to_char() is there any way to
> > have the month appear as Feb instead of FEB? (ie: is there a function
> > to only capitalize the first character of a text field or etc...)

> SQL> select to_char(sysdate, 'Mon') from dual;

And generally for strings, look for the INITCAP function.

G Received on Thu Feb 24 2005 - 16:04:08 CST