Oracle Interview Question

explain time data handling in SQL