Title: Describe date/time data types.
Course: Database Design and Management (Oracle) (10052) > Section: Modifying and Managing Tables

Description should include the following:

- DATE—stores point-in-time data in a table, and stores century, year, month, day, hours, minutes, and seconds
- knowing the default date format—DD-Mon-YYYY
- TIMESTAMP—stores values that are precise to within fractions of a second
- TIMESTAMP WITH TIME ZONE—stores time zone information in instances when coordination across geographic areas is important
- TIMESTAMP WITH LOCAL TIME ZONE—for use when the time zone is less important or when the time zone of the client system must be displayed