Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Any was to format the Month to Display as 'Feb'?
raj wrote:
> Try this!
>
> select upper(to_char(sysdate, 'Mon')) from dual;
>
That would precisely do exactly what the OP does NOT want done. INITCAP would have been the correct answer.
-- Daniel A. Morgan University of Washington damorgan_at_x.washington.edu (replace 'x' with 'u' to respond)Received on Fri Feb 25 2005 - 01:29:42 CST