Datetime
Values
A DATE value designates a point in time by the components year (0001 to 9999), month (1 to 12) and day (1 to 28, 29, 30, 31 depending on the month and year).
A TIME value designates a time of day by the components hour (0 to 24), minute (0 to 59) and second (0 to 59).
A TIMESTAMP value designates a point in time represented by a date and time as defined previously including a fractional specification of seconds with a portable precision of tens of milliseconds.
The DATE and TIME types are not time-zone aware. This means that they behave as if the values were stored in string representation. The TIMESTAMP type, however, is time-zone aware. Values of this type are always stored as UTC timestamps.
More Information