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