ORA-01861: literal does not match format string

by

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.

More Related Contents:

  1. Merging two tables in SQL [closed]
  2. Is it possible to output a SELECT statement from a PL/SQL block?
  3. Pivoting rows into columns dynamically in Oracle
  4. Using ‘case expression column’ in where clause
  5. Oracle Joins – Comparison between conventional syntax VS ANSI Syntax
  6. Concatenate results from a SQL query in Oracle
  7. How to use BOOLEAN type in SELECT statement
  8. How to kill a running SELECT statement
  9. Convert a string date into datetime in Oracle
  10. Selecting the second row of a table using rownum
  11. Update with Join query in Oracle
  12. How to count the number of occurrences of a character in an Oracle varchar value?
  13. Different CURRENT_TIMESTAMP and SYSDATE in oracle
  14. Oracle date “Between” Query
  15. Oracle Date TO_CHAR(‘Month DD, YYYY’) has extra spaces in it
  16. Query a Table’s Foreign Key relationships
  17. Is there an Oracle equivalent to SQL Server’s OUTPUT INSERTED.*?
  18. The most efficient way to UPPER CASE two columns in a single query [closed]
  19. I want to search job and salary from employee table but I am getting error like invalid relational operator [closed]
  20. Case insensitive searching in Oracle
  21. How to find the employee with the second highest salary?
  22. Oracle: What does `(+)` do in a WHERE clause?
  23. Equivalent function for DATEADD() in Oracle
  24. Anonymous TABLE or VARRAY type in Oracle
  25. How do I convert a “legacy” left outer join statement in Oracle?
  26. How to Alter Constraint
  27. Group by with CLOB in select-statement
  28. Oracle/SQL: Why does query “SELECT * FROM records WHERE rownum >= 5 AND rownum
  29. SQL Server equivalent of WM_CONCAT function [duplicate]
  30. Oracle: ‘= ANY()’ vs. ‘IN ()’

Leave a Comment