ORA-01843: not a valid month

[jaya kemmannu]

Hi,

   Anybody is able help me find out error in below SQL Query :

select count(tn) from routing_info where RECIPIENT_ID in ('103') and LAST_MODIFIED_TIME >= TO_char(SYSDATE - INTERVAL '16' HOUR, 'dd/MM/yyyy HH24:MI:SS') and LAST_MODIFIED_TIME <= TO_char(SYSDATE, 'dd/mm/yyyy HH24:MI:SS') ;

Error : ORA-01843: not a valid month

Regards,
Jaya

[chris webster]

Your LAST_MODIFIED_TIME is (presumably) a date-time, but you are comparing it with character values from your TO_CHAR functions. Leave all the dates as dates and it should work. Also, you can use "BETWEEN date1 AND date2" to catch dates inside a range.