Oracle Database Discussions

Hi, Expert

ORACLE 11.2.0.4

SQL*PLUS

SQL> desc log_table

NAME     TYPE

-------- --------------

PROG        VARCHAR(20)

BEGIN_TIME  DATE

END_TIME    DATE

I want to get elapsed time in seconds (END_TIME-BEGIN_TIME)

This is my query ...

    select prog,(END_TIME-BEGIN_TIME)*86400 from log_table;

but

    Some of returned rows are not integer (for example 11.0000000....0000002,   6300.99999999999999)

The precision of Oracle DATE data type is second ....

How can it(caculation of date type) be not integer ?

--- oracle concept manual

The DATE datatype stores the year (including the century), the month, the day, the hours, the minutes, and the seconds.

Thanks in advance