Hi,
I have a Oracle query which runs fine at Oracle side(through TOAD or Oracle Client).
I am using sysdate+1 in my query to get the next date.
Now I am using same query in RS using Oracle Client which returns error "ORA-00932:Inconsistent datatypes.Expected DATE got NUMBER".
Basically the driver is unable to interpret to add 1(Number) to the Sysdate(Date) field.
Any suggestions/ideas are greatly appreciated.
Thanks !!
Maybe in your query you should do an explicit CONVERT back to date on the sysdate + 1 expression? I think you may be relying on an implicit conversion which is not happening in this case.
No comments:
Post a Comment