ORA-01843 not a valid month- Comparing Dates

I have a problem when try to select data from a table filtering by date.

For example:

SELECT * FROM MYTABLE WHERE MYTABLE.DATEIN = '23/04/49';

The Oracle Error is:

Informe de error:
Error SQL: ORA-01843: mes no válido
01843. 00000 -  "not a valid month"
*Cause:    
*Action:

Probably the source data of table is corrupted, in this case:

  • How can i solve this problem?
  • Can I change this dates for null?

The results of this select, select * from nls_session_parameters; , is:

PARAMETER                      VALUE                                  
------------------------------ ----------------------------------------
NLS_LANGUAGE                   SPANISH                                  
NLS_TERRITORY                  SPAIN                                    
NLS_CURRENCY                   ¿                                        
NLS_ISO_CURRENCY               SPAIN                                    
NLS_NUMERIC_CHARACTERS         ,.                                       
NLS_CALENDAR                   GREGORIAN                                
NLS_DATE_FORMAT                DD/MM/RR                                 
NLS_DATE_LANGUAGE              SPANISH                                  
NLS_SORT                       SPANISH                                  
NLS_TIME_FORMAT                HH24:MI:SSXFF                            
NLS_TIMESTAMP_FORMAT           DD/MM/RR HH24:MI:SSXFF                   
NLS_TIME_TZ_FORMAT             HH24:MI:SSXFF TZR                        
NLS_TIMESTAMP_TZ_FORMAT        DD/MM/RR HH24:MI:SSXFF TZR               
NLS_DUAL_CURRENCY              ¿                                        
NLS_COMP                       BINARY                                   
NLS_LENGTH_SEMANTICS           BYTE                                     
NLS_NCHAR_CONV_EXCP            FALSE

Related Posts:

  1. DATEDIFF function in Oracle
  2. ORA-00904: invalid identifier
  3. How do I UPDATE from a SELECT in SQL Server?
  4. how to fix oracle ORA-01722 invalid number error
  5. SQL SELECT WHERE field contains words
  6. SQL SELECT WHERE field contains words
  7. ORA-00979 not a group by expression
  8. ORA-00907: missing right parenthesis
  9. SQL SELECT WHERE field contains words
  10. How to implement one-to-one, one-to-many and many-to-many relationships while designing tables?
  11. ORA-00918: column ambiguously defined in SELECT *
  12. Teradata: how to convert varchar value (format ‘dd.mm.yyyy’) to date (format ‘yyyy-mm-dd’ )?
  13. Oracle error : ORA-00905: Missing keyword
  14. How do I limit the number of rows returned by an Oracle query after ordering?
  15. Oracle SELECT TOP 10 records
  16. Can a foreign key be NULL and/or duplicate?
  17. How to Select Top 100 rows in Oracle?
  18. ORA-12560: TNS:protocol adaptor error
  19. Best way to do nested case statement logic in SQL Server
  20. ORA-00972 identifier is too long alias column name
  21. ORA-01830: date format picture ends before converting entire input string / Select sum where date query
  22. Oracle Apex column link from LOV values
  23. PLS-00103: Encountered the symbol when expecting one of the following:
  24. What’s the difference between RANK() and DENSE_RANK() functions in oracle?
  25. ORA-00918: column ambiguously defined in SELECT *
  26. ORA-00918: column ambiguously defined in SELECT *
  27. Oracle – ORA-01489: result of string concatenation is too long [duplicate]
  28. ORA-01861: literal does not match format string
  29. What is it exactly a BLOB in a DBMS context
  30. “ORA-01438: value larger than specified precision allowed for this column” when inserting 3
  31. How do you create a temporary table in an Oracle database?
  32. Oracle “Partition By” Keyword
  33. How to insert date values into table
  34. Oracle SQL: Update a table with data from another table
  35. SQL selecting rows by most recent date with two unique columns
  36. how to remove time from datetime
  37. ORA-06502: PL/SQL: numeric or value error: character string buffer too small
  38. How to write a SQL DELETE statement with a SELECT statement in the WHERE clause?
  39. Comparing Dates in Oracle SQL
  40. Convert timestamp to date in Oracle SQL
  41. How do I reset a sequence in Oracle?
  42. Query to convert from datetime to date mysql
  43. SQL: Two select statements in one query
  44. Update statement with inner join on Oracle
  45. SQL conditional SELECT
  46. MySQL equivalent of DECODE function in Oracle
  47. Oracle: If Table Exists
  48. How to create id with AUTO_INCREMENT on Oracle?
  49. LEFT function in Oracle
  50. MySQL error: Unknown column in ‘where clause’
  51. What is the difference between Views and Materialized Views in Oracle?
  52. Postgresql column reference “id” is ambiguous
  53. How do I view the Explain Plan in Oracle Sql developer?
  54. How to order by column A and then by column B?
  55. ORA-01779: cannot modify a column which maps to a non key-preserved table
  56. ORA-01735: invalid ALTER TABLE option – Toad
  57. ora-06553 pls-306 wrong number or types of arguments in call to ‘ogc_x’
  58. Help me SELECT thumbnail from SQL and use
  59. How to change post published date to today date with SQL
  60. how to SELECT meta values that are not null?
  61. What is the difference between “INNER JOIN” and “OUTER JOIN”?
  62. Case in Select Statement
  63. How can I do an UPDATE statement with JOIN in SQL Server?
  64. How do I use properly CASE..WHEN in MySQL
  65. INSERT statement conflicted with the FOREIGN KEY constraint – SQL Server
  66. IDENTITY_INSERT is set to OFF – How to turn it ON?
  67. How to reset AUTO_INCREMENT in MySQL
  68. What does SQL Select symbol || mean?
  69. Why does NULL = NULL evaluate to false in SQL server
  70. Difference between one-to-many and many-to-one relationship
  71. missing FROM-clause entry for table
  72. MySQL Error 1264: out of range value for column
  73. How to parse XML data in SQL server table
  74. Determine ROW that caused “unexpected end of file” error in BULK INSERT?
  75. Sql query to insert datetime in SQL Server
  76. Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 1, column 4 (Year)
  77. How to divide two columns?
  78. MySQL starts with searching issue
  79. SQL “select where not in subquery” returns no results
  80. ListAGG in SQLSERVER
  81. grant select on view
  82. The used SELECT statements have a different number of columns
  83. Equivalent of explode() to work with strings in MySQL
  84. How to calculate age (in years) based on Date of Birth and getDate()
  85. Text was truncated or one or more characters had no match in the target code page including the primary key in an unpivot
  86. Append table to an existing one: SQL Server
  87. SQL Server – An expression of non-boolean type specified in a context where a condition is expected, near ‘RETURN’
  88. Update query using Subquery in Sql Server
  89. How to convert java.util.Date to java.sql.Date?
  90. register_post_status – show_in_admin_all_list & show_in_admin_status_list does not affect query
  91. Return number of items in a table with post id
  92. Debugging WordPress
  93. Pull data and display as rows and columns
  94. I need a SQL command to delete specific authors and all posts connected with them
  95. How can i restore only Blogs from a SQL backup file?
  96. DB_HOST – is LOCALHOST speedy than domain name? [closed]
  97. Do I need to sanitize $_POST[‘keyword’] before send to ‘s’ parameter?
  98. Sql query returns empty. But not
  99. Adding profile data to database
  100. Deleting the MySQL database

Leave a Comment