Report Column function to calculate days between two dates

Content

All,

As the title suggests, I'm attempting to use functions to calculate days between two dates, however I have not been successful to have the function return the result in full days, below is my code. The parameter "packageName$ObjectName.Date" is of "Date" data type. As is, the result of this code is a rather large number (I'm assuming seconds).

Any advice would be appreciated.

Version

May 2016

Code Snippet

             to_number(time_format(date_diff(packageName$ObjectName.Date,sysdate()),'DD'))