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

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...)
>
> Thanks,

Certainly:

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

TO_

---
Feb

SQL>


David Fitzjarrell