it.toolbox.com
A Comparison of Oracle's DATE and TIMESTAMP Datatypes
If you want to store date and time information in Oracle, you really only have two different options for the column’s datatype. Lets take a quick look at these two datatypes and what they offer.