Both datetime and interval data types consist of fields.
For some reason, I can't recall the number of the department but I know its manager has the last name Haas, which is written entirely in uppercase in the database.
I also know that the MGRNO column in the Department table contains the employee number of the employee who manages the department.
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.