Oracle: Why is the query not fetching the records for the date I wanted?

Question

SELECT EMP_NAME, SSN FROM EMP WHERE HIER_DATE = TO_DATE('03-NOV-1999','DD-MON-YYYY');

Comments

Please provide the query which you are using