SQL statement

[jrthor2]

Can someone tell me why I get rows back with dates from 2003 from the below SQL statement:

SELECT EVENT, to_char(EVENT_DTE, 'MM/DD/YYYY') MYDISPLAYDATE, SEQ_NBR,CITY, ST, LOCN, LOCN_ADDR, LOCN_CITY, LOCN_ST, LOCN_ZIP, LOCN_AREA_CODE, LOCN_EXCHANGE, LOCN_EXTENSION, HOURS, TOPIC, CONTACT, CNTCT_AREA_CODE, CNTCT_EXCHANGE, CNTCT_EXTENSION, CNTCT_EMAIL FROM SYSADM.INJOH_RX_EVENTS WHERE EVENT = 'PHARMACIST - OPEN HOUSE SCHEDULE' and to_char(EVENT_DTE, 'MM/DD/YYYY') >= '01/05/2004' order by MYDISPLAYDATE

thanks!!

[sjfoong]

Try this.

SELECT EVENT, to_char(EVENT_DTE, 'MM/DD/YYYY') MYDISPLAYDATE, SEQ_NBR,CITY, ST, LOCN, LOCN_ADDR, LOCN_CITY, LOCN_ST, LOCN_ZIP, LOCN_AREA_CODE, LOCN_EXCHANGE, LOCN_EXTENSION, HOURS, TOPIC, CONTACT, CNTCT_AREA_CODE, CNTCT_EXCHANGE, CNTCT_EXTENSION, CNTCT_EMAIL FROM SYSADM.INJOH_RX_EVENTS WHERE EVENT = 'PHARMACIST - OPEN HOUSE SCHEDULE' and EVENT_DTE >= to_date('01 may 2004', 'dd/mm/yyyy') order by MYDISPLAYDATE

[jrthor2]

THANKS, that seems to work