I'm trying to find the days pasted between two dates.
I have the commands correct because they are verbatim to what my book says, but the the result's formatting is wrong or I'm just doing something wrong.

Here is what I have:

Code:
SELECT ORDER_NUM, SYSDATE() AS TODAYS_DATE, ORDER_DATE, ROUND(SYSDATE() - ORDER_DATE,2) AS DAYS_PAST
FROM ORDERS;
RESULT:
'51608', '2015-11-11 17:21:58', '2015-10-12', '20151091021146'

'20151091021146' should be 30.53

I can get the correct results by using DATEDIFF(), but it removes the decimals, and I really need the decimals.

Any suggestions?