Good morning Hozawa, The SQL query was executed in the Oracle SQL Developer and work correctly, but in JasperReports I have the error. Thanks for your answer.
I have the follow error with a report: "Error: SQL problems:ORA-01840: input value not long enough for date format. I would be to know the cause. Can anyone help me please?