ORA-01861: literal does not match format string

When I try to execute this snippet:

cmd.CommandText = "SELECT alarm_id,definition_description,element_id,
    TO_CHAR (alarm_datetime, 'YYYY-MM-DD HH24:MI:SS'),severity,
    problem_text,status FROM aircom.alarms 
    WHERE status = 1 and 
    TO_DATE (alarm_datetime,'DD.MM.YYYY HH24:MI:SS') > TO_DATE ('07.09.2008 
    09:43:00', 'DD.MM.YYYY HH24:MI:SS') 
    order 
    by ALARM_DATETIME desc";

I get:

ORA-01861: literal does not match format string

There is no problem with database connection because I can execute basic SQL commands.

What is the problem with this statement?

Related Posts:

  1. How to insert date values into table
  2. ora-06553 pls-306 wrong number or types of arguments in call to ‘ogc_x’
  3. ORA-00904: invalid identifier
  4. how to fix oracle ORA-01722 invalid number error
  5. ORA-00979 not a group by expression
  6. ORA-00907: missing right parenthesis
  7. How to implement one-to-one, one-to-many and many-to-many relationships while designing tables?
  8. ORA-01843 not a valid month- Comparing Dates
  9. ORA-00918: column ambiguously defined in SELECT *
  10. Oracle error : ORA-00905: Missing keyword
  11. How do I limit the number of rows returned by an Oracle query after ordering?
  12. Oracle SELECT TOP 10 records
  13. Can a foreign key be NULL and/or duplicate?
  14. How to Select Top 100 rows in Oracle?
  15. ORA-12560: TNS:protocol adaptor error
  16. ORA-00972 identifier is too long alias column name
  17. Oracle Apex column link from LOV values
  18. PLS-00103: Encountered the symbol when expecting one of the following:
  19. What’s the difference between RANK() and DENSE_RANK() functions in oracle?
  20. ORA-00918: column ambiguously defined in SELECT *
  21. ORA-00918: column ambiguously defined in SELECT *
  22. Oracle – ORA-01489: result of string concatenation is too long [duplicate]
  23. What is it exactly a BLOB in a DBMS context
  24. “ORA-01438: value larger than specified precision allowed for this column” when inserting 3
  25. How do you create a temporary table in an Oracle database?
  26. Oracle “Partition By” Keyword
  27. Oracle SQL: Update a table with data from another table
  28. SQL selecting rows by most recent date with two unique columns
  29. ORA-06502: PL/SQL: numeric or value error: character string buffer too small
  30. Comparing Dates in Oracle SQL
  31. Convert timestamp to date in Oracle SQL
  32. How do I reset a sequence in Oracle?
  33. Update statement with inner join on Oracle
  34. MySQL equivalent of DECODE function in Oracle
  35. Oracle: If Table Exists
  36. DATEDIFF function in Oracle
  37. How to create id with AUTO_INCREMENT on Oracle?
  38. LEFT function in Oracle
  39. What is the difference between Views and Materialized Views in Oracle?
  40. How do I view the Explain Plan in Oracle Sql developer?
  41. ORA-01779: cannot modify a column which maps to a non key-preserved table
  42. ORA-01735: invalid ALTER TABLE option – Toad
  43. Unknown column in ‘field list’ error on MySQL Update query
  44. The wait operation timed out. ASP
  45. How to create Temp table with SELECT * INTO tempTable FROM CTE Query
  46. Using group by on multiple columns
  47. Efficiently convert rows to columns in sql server
  48. Nested select statement in SQL Server
  49. What’s the difference between VARCHAR and CHAR?
  50. How to split the name string in mysql?
  51. Sql Server equivalent of a COUNTIF aggregate function
  52. Column name or number of supplied values does not match table definition
  53. Simple PHP Pagination script
  54. CREATE VIEW must be the only statement in the batch
  55. SQL Server FOR EACH Loop
  56. SQL – HAVING vs. WHERE
  57. MySQL combine two columns into one column
  58. SQL Error: ORA-00913: too many values
  59. How to SUM two fields within an SQL query
  60. DateTime2 vs DateTime in SQL Server
  61. SQL Server Insert if not exists
  62. SQL Server: Invalid Column Name
  63. String or binary data would be truncated. The statement has been terminated
  64. Error converting data type varchar to float
  65. How to concatenate text from multiple rows into a single text string in SQL Server
  66. Count(*) vs Count(1) – SQL Server
  67. Arithmetic overflow error converting numeric to data type numeric
  68. Remove duplicate rows in MySQL
  69. “You tried to execute a query that does not include the specified aggregate function”
  70. How to write a SQL DELETE statement with a SELECT statement in the WHERE clause?
  71. How to round down to nearest integer in MySQL?
  72. MySQL error: key specification without a key length
  73. SQL: Two select statements in one query
  74. Check if MySQL table exists without using “select from” syntax?
  75. mysql update column with value from another table
  76. what is the difference between triggers, assertions and checks (in database)
  77. ‘NOT LIKE’ in an SQL query
  78. Replacing NULL with 0 in a SQL server query
  79. SQL Server dynamic PIVOT query?
  80. How to delete from multiple tables in MySQL?
  81. How to copy a row and insert in same table with a autoincrement field in MySQL?
  82. What does Include() do in LINQ?
  83. SQL Server “cannot perform an aggregate function on an expression containing an aggregate or a subquery”, but Sybase can
  84. Get everything after and before certain character in SQL Server
  85. What are database constraints?
  86. Postgresql column reference “id” is ambiguous
  87. SQLite string contains other string query
  88. Cannot insert explicit value for identity column in table ‘table’ when IDENTITY_INSERT is set to OFF
  89. Sorting search results by taxonomy terms
  90. WordPress SQL LIKE request doesn’t work for fields with special symbols
  91. WordPress database error: You have an error in your SQL syntax
  92. Better way to migrate to server?
  93. Inner Join user tables to select users with roles
  94. $wpdb->prepare with LIKE returning blank array instead of rows
  95. WooCommerce database query : Get product category image path+name from thumbnail_id [closed]
  96. WordPress can I manually add columns in users table and display it in the default manage user plugin and registration form? [closed]
  97. Help me SELECT thumbnail from SQL and use
  98. Why is my insert row only inserting the final row from the loop into the database rather than just inserting one
  99. Creating a “forum” – showing last post or last commented post
  100. Replace Unwanted Space in Post Content URL

Leave a Comment