The available date and time conversions depend on the datatype.
-
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.