Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: How to get the month part of an Oracle date field?
On Mar 19, 5:22 pm, Geoff Muldoon <geoff.muld..._at_trap.gmail.com>
wrote:
> sherifffruit..._at_gmail.com says...
>
> > The field as_of_date is a date field. How do I get the month-part of
> > it, to test for equality with the input?
>
> The TO_CHAR inbuilt Oracle function will convert an Oracle date to a
> character string. The arguments passed in format string component of the
> function include a MONTH_OF_YEAR option. Look up the doco.
>
> http://download-east.oracle.com/docs/cd/B19306_
> 01/server.102/b14200/functions180.htm
>
> http://download-east.oracle.com/docs/cd/B19306_
> 01/server.102/b14200/sql_elements004.htm
>
> GM
Awesome - thanks! Received on Mon Mar 19 2007 - 22:34:48 CDT