I was told there would be no (date) math
- From: "Jesse, Rich" <Rich.Jesse@xxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 13 Apr 2006 08:51:50 -0500
Hey all,
While debugging an analytical function issue using 9.2.0.5, I run this
idiotic query:
SELECT TRUNC(SYSDATE) - TRUNC(SYSDATE) - TRUNC(SYSDATE)
FROM DUAL;
And it errors out with:
ORA-00932: inconsistent datatypes: expected DATE got DATE
(In 10.2, the verbage is modified to "expected JULIAN DATE got DATE")
Add parenthesis and it works:
SELECT TRUNC(SYSDATE) - (TRUNC(SYSDATE) - TRUNC(SYSDATE))
FROM DUAL;
I've been looking through the docs and Metalink, but I'm unable to
answer "Why?". Anyone?
TIA!
Rich
--
//www.freelists.org/webpage/oracle-l
Other related posts:
