trunc(sysdate) V6 vs V7

Hello

What are the differences in the way that trunc(sysdate) works in version 7 compared with version 6 in Oracle?

Example :
startdate is a database field and is of date format.

Version 6 - This works as expected

          trunc(sysdate) - startdate

Version 7 - NOT as expected

          trunc(sysdate) - startdate
Version 7 - Works OK

          trunc(sysdate) - trunc(startdate) Version 7 - Works OK

          sysdate - startdate

I have loads of code to possibly change and would like some proper confirmation that there are differences for the boss ;-)

Thanks
--
Amanda Pickard Received on Sun Jul 19 1998 - 18:41:10 CDT