Hi friends,
I need a help in Discoverer report. My Report was working fine with this date format but when on this Monday my DBA upgraded the application with new version it started giving me an error. Error is
An error occurred while trying to run the query.
(Inconsistent or invalid data types used in arithmetic operation)
Actually getting this error because of date condition and that condition is:
to_date(‘8-oct-2004’,’dd-mon-yyyy’) - to_number(to_char(to_date(‘8-oct-2004’,’dd-mon-yyyy’),’D’)-1)
Basically this condition calculates the previous Sunday date of whatever date you have passed.
It seems to me that to_char(to_date(‘8-oct-2004’,’dd-mon-yyyy’),’D’) is not supporting in newer version of discoverer. I am not sure just guessing.
Can anyone help me how to resolve this issue?
Anju
I need a help in Discoverer report. My Report was working fine with this date format but when on this Monday my DBA upgraded the application with new version it started giving me an error. Error is
An error occurred while trying to run the query.
(Inconsistent or invalid data types used in arithmetic operation)
Actually getting this error because of date condition and that condition is:
to_date(‘8-oct-2004’,’dd-mon-yyyy’) - to_number(to_char(to_date(‘8-oct-2004’,’dd-mon-yyyy’),’D’)-1)
Basically this condition calculates the previous Sunday date of whatever date you have passed.
It seems to me that to_char(to_date(‘8-oct-2004’,’dd-mon-yyyy’),’D’) is not supporting in newer version of discoverer. I am not sure just guessing.
Can anyone help me how to resolve this issue?
Anju