Hi All,

I have a following query
select tdjwm467.*
from tdjwm467 for update
where tdjwm467._index2 = {2,3,:tdpur401.orno , :tdpur401.pono}
and cast(tdjwm467.trdt as date ) = cast(:tdpur401.ddte as date )


The code compiles . However cast condition does not seem to work . Am i doing anything wrong here .

Hi All,

I have a following query


The code compiles . However cast condition does not seem to work . Am i doing anything wrong here .

Hello,

I am not sure but does cast function handle utc.num, date.num conversions? Maybe its related with that.

Best regards