Hi Team,
I ran one report in cognos 7 , it gives output , but same report while executing in cognos10, it throws error , attached.
the syntax is :
([Container Tracking Package].[History Tracking].[STATUS_DATETIME]) >= cast_date(?DateFrom?) and
([Container Tracking Package].[History Tracking].[STATUS_DATETIME]) <= _add_days(cast_date(?DateTo?);1)
Kindly Suggest me ,whether anything needs to be added.
Thanks in advance.
Regards
Inam
Quote from: inu on 13 Jul 2015 04:11:50 AM
Hi Team,
I ran one report in cognos 7 , it gives output , but same report while executing in cognos10, it throws error , attached.
the syntax is :
([Container Tracking Package].[History Tracking].[STATUS_DATETIME]) >= cast_date(?DateFrom?) and
([Container Tracking Package].[History Tracking].[STATUS_DATETIME]) <= _add_days(cast_date(?DateTo?);1)
Kindly Suggest me ,whether anything needs to be added.
Thanks in advance.
Regards
Inam
Hi,
Did you make any effort to research the error? I just took the error code (ORA-01830) and put it into Google and got myriad hits. Here is one:
http://stackoverflow.com/questions/20219363/ora-01830-date-format-picture-ends-before-converting-entire-input-string-sele
It is an error from your ORACLE database saying you should not be relying on implicit date conversion in your expression.
What data type is STATUS_DATETIME? Why are you using a cast_date() function?
MF.