ora-00936

Try this: select count(*) from ibc_offer where DEACTIVATION_DTTM > TO_DATE(’31/12/9999 23:00:00′,’dd/mon/yyyy HH24:MI:SS’) and DEACTIVATION_DTTM < TO_DATE(’31/12/9999 23:59:59′,’dd/mon/yyyy HH24:MI:SS’); What is the mistake in your query? you missed date keyword in the second comparison after and. Your query should be like below: select count(*) from ibc_offer where DEACTIVATION_DTTM > date(‘31.12.9999 23:00:00′,’DD.MM.YYYY HH:MI:SS’) and DEACTIVATION_DTTM < date(‘31.12.9999 … Read more