Extracting month from Date PL/SQL

• daveap

  SSC Enthusiast

  Points: 183

  More actions

  April 17, 2012 at 12:45 pm

  #255036

  I have to provide month_of_date in my query, I tried following function in Oracle but it gives me error, any other suggestion. Please see my query below.

  SELECT waf.activity_count

  , waf.oid,

  , WAF.EVENT_TYPE

  , WAF.IDENTITY_ID,

  extract (month from WAF.ACTIVITY_DATE)

  FROM GMMI_AIR.web_activity_fct waf

  WHERE 1=1

  AND (WAF.ACTIVITY_DATE)) BETWEEN '1-APR-2010'

  AND '31-MAR-2012'

  I have to show my column as Month_of_date and have no clue how do I extract month in Oracle functions.

  Thanks a bunch!!!

• Mike01

  SSChampion

  Points: 11395

  More actions

  April 17, 2012 at 12:48 pm

  #1474961

  You do realize that this forum is for SQL Server?

  For better, quicker answers, click on the following...
  http://www.sqlservercentral.com/articles/Best+Practices/61537/

  For better answers on performance questions, click on the following...
  http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

• Lynn Pettis

  SSC Guru

  Points: 442467

  More actions

  April 17, 2012 at 12:52 pm

  #1474964

  Got my posts backwards. Duplicate post, please post answers here, the Working with Oracle forum.