Re: How to get the month part of an Oracle date field?

From: Geoff Muldoon <geoff.muldoon_at_trap.gmail.com>
Date: Tue, 20 Mar 2007 11:22:33 +1100
Message-ID: <MPG.2069d4509cd535979898f7@news.readfreenews.net>

sherifffruitfly_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 Received on Mon Mar 19 2007 - 19:22:33 CDT