Error executing sql query

Question

I try to execute the following query using java.sql.PreparedStatement:

SELECT  NVL (tb.ddate, '2002-10-15')
FROM tb

But get this error:

java.sql.SQLException: ORA-01843: ¿¿¿¿ ¿¿ ¿¿¿

What is wrong?

Wrong date format? Month is usually in JAN, FAB or like that — Bhrugesh Patel
– Bhrugesh Patel, Commented Feb 28, 2012 at 20:44
@BhrugeshPatel: that is absolutely perfect date format. (October, 15th, 2002) — user330315
– user330315, Commented Feb 28, 2012 at 21:56

dani herrera · Accepted Answer · 2012-02-28 20:43:32Z

3

The date is not in expected format.

Or try:

SELECT  NVL (tb.ddate, to_date('2002-10-15', 'YYYY-MM-DD') )
FROM tb

answered Feb 28, 2012 at 20:43

dani herrera

52k11 gold badges133 silver badges188 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1