[Solved] Pls can you help me? [closed]

by


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 23:59:59','DD.MM.YYYY HH:MI:SS');

0

solved Pls can you help me? [closed]