(Bob Watkins) Before version 9i, Oracle had no built-in way to record the passage of time. The DATE datatype records an individual moment in time; but to express a quantity of time (i.e., an interval), database designers had to convert the interval to raw seconds and use a NUMBER column to store it.
Read More - Register for Free Membership
SQL Server, Azure SQL Database, Amazon RDS & AWS, Oracle and IBM Help