Help with SQL statement

[jrthor2]

I want to show articles in a database for only the current month. My table only has 1 field for the date (DISPLAY_DTE). Below is my SQL statement, how do I only select articles for the current month?


SQLstmt = "SELECT EVT.ITEM_NBR, TYP.EVENT_TYPE, TITLE_TXT,
to_char(DISPLAY_DATE, 'MM/DD/YYYY') MYDISPLAYDATE
FROM SYSADM.INDYH_DYNCONTENT_HTML EVT,
SYSADM.INDYT_DYNCONTENT_TYPE TYP
WHERE EVT.ITEM_NBR = TYP.ITEM_NBR
AND TYP.EVENT_TYPE IN ('national','financial','people','community')
AND DISPLAY_DTE >= ???????????
AND EVT.STATUS_IND = 'APPROVED'
ORDER BY DISPLAY_DATE DESC"

[magus]

try this code

AND to_char(DISPLAY_DTE, 'MM') = to_char(GETDATE(),'MM')