TIME datatypes cannot be converted between types.
DATE datatypes are converted to DATETIME by setting the time portion to midnight.
DATETIME datatypes cannot be converted to dates or times.