Menu
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!!