Skip to content
Advertisement

java.sql.SQLException: ORA-01843: not a valid month

I am getting the following error when inserting data into my oracle database.

In database date is as: dd-MMM-yy (06-MAR-12)
I am converting 06-03-2012 to dd-MMM-yy by the following method:

So i got 06-Mar-12 which is same as the above database date format still i am getting the error. I am inserting as:

in index.jsp

in servlet(doPost)

Any idea please

Advertisement

Answer

so make

Try this

// gets from Oracle docs

User contributions licensed under: CC BY-SA
4 People found this is helpful
Advertisement