Try TO_CHAR(TO_DATE(HOTOOFFERDATE,'DD-MM-YY, HH:MI:SS') ,'MMYYYY') = TO_CHAR(TO_DATE(PHOTODATE,'DD-MM-YY'),'MMYYYY')