ORA-01861: literal does not match format string
Remove the TO_DATE in the WHERE clause TO_DATE (alarm_datetime,’DD.MM.YYYY HH24:MI:SS’) and change the code to alarm_datetime The error comes from to_date conversion of a date column. Added Explanation: Oracle converts your alarm_datetime into a string using its nls depended date format. After this it calls to_date with your provided date mask. This throws the exception.