ORA-01843: not a valid month to_date(substr(:processdate, 1, 11), 'mm/dd/YYYY')

See more:

SQL

Hi all,

in my oracle table I have a column called :

processdate

datatype date.

Process date value in table is :

6/5/2018

trying to run the below query getting exception .

SELECT to_date(substr(:processdate, 1,10), 'mm/dd/YYYY') FROM table

if I enter processdate :

6/5/2018

it was throwing exception like

A-01843: not a valid month

please guide me what is wrong with this query.

Thanks inadvance.

What I have tried:

<pre>SELECT to_date(substr(:processdate, 1,10), 'mm/dd/YYYY') FROM table

if I enter processdate :

6/5/2018

it was throwing exception like

A-01843: not a valid month