There are 4 additional Date and/or Time Data Types for handling specific situations

DATE

YEAR

TIME

TIMESTAMP

If you do not care about time and only need the date

If you do not care about date and only need the time

If you only need the Year

This Type is similar to DATETIME but reacts differently and has a few issues

Commonly Used to Date Tag Log Files

Reacts to Changing your time zone

Subject to the Y2K38 Problem

The Other Date And Time Options