ORA-01858 error-to_date() in sql

Asked Mar 10 '16 at 04:00

Active Jun 07 '18 at 08:57

Viewed 393 times

I'm using the query

select to_date(DateString,'MM/dd/yy hh24:mi:ss')
from tableName
where to_date(DateString,'MM/dd/yy hh24:mi:ss') between to_date('2015-10-01','yyyy-MM-dd') and to_date('2015-10-31','yyyy-MM-dd');

the result is: ORA-01858:a non-numeric character was found where a numeric was expected. Here, the DateString column data type is Varchar2, not nullable. Values of DateString is:

10/11/15 20:14
10/21/15 11:36
10/25/15 17:50

I don't understand where I have done mistake.

edited Jun 07 '18 at 08:57

vCillusion

1,749
20
33

asked Mar 10 '16 at 04:00

radhik

If you don't have a seconds component, why is that in the format string? – Gordon Linoff Mar 10 '16 at 04:10
@Gordon I removed it from format string. Received the same error now also. – radhik Mar 10 '16 at 04:36
You probably have malformed data in your table. – cstotzer Mar 10 '16 at 09:02
If the column has malformed data, it should work for few years/months. Even I tried with different years/months, it is not working... – radhik Mar 10 '16 at 11:21

ORA-01858 error-to_date() in sql

0 Answers0