ORA-01843 Not a valid month

by

Always be specific when you have dates formatted as text: do the conversion explicitly with the correct date/time format for your data.

to_date('14/04/2015', 'DD/MM/YYYY')

Do that for all date inputs.

More Related Contents:

  1. How do I specify date literal when writing SQL query from SQL Server that is linked to Oracle?
  2. Why do we combine several select statements
  3. Is there a combination of “LIKE” and “IN” in SQL?
  4. How ROWNUM works in pagination query?
  5. Get list of all tables in Oracle?
  6. Removing duplicate rows from table in Oracle
  7. Oracle: If Table Exists
  8. Using ‘case expression column’ in where clause
  9. Oracle SQL escape character (for a ‘&’)
  10. SQL Error: ORA-00933: SQL command not properly ended
  11. CASE vs. DECODE
  12. Convert a string date into datetime in Oracle
  13. DATEDIFF function in Oracle [duplicate]
  14. Pivoting of data using two columns
  15. Check if current date is between two dates Oracle SQL
  16. Benefits Of Using SQL Ordinal Position Notation?
  17. Unordered results in SQL
  18. Oracle Dynamic Pivoting
  19. Foreign Key Creation issue in Oracle
  20. create custom function for date difference excluding weekends and holidays in oracle sql
  21. What is it exactly a BLOB in a DBMS context
  22. Custom Order in Oracle SQL
  23. How do I list all tables in a schema in Oracle SQL?
  24. Compare Strings ignoring accents in SQL (ORACLE)
  25. How to insert a string which contains an “&”
  26. Subtracting Dates in Oracle – Number or Interval Datatype?
  27. Retrieve Oracle last inserted IDENTITY
  28. Using bind variables with dynamic SELECT INTO clause in PL/SQL
  29. Why are aggregate functions not allowed in where clause
  30. Insert into from CTE

Leave a Comment