If you attempt to explicitly convert a date to a
datetime, and the value is outside the datetime range
such as “Jan 1, 1000” the conversion is not allowed and an informative error message is
raised.
Example of Explicit Conversion
DATE -> UNICHAR, UNIVARCHAR
TIME -> UNICHAR, UNIVARCHAR
UNICHAR, UNIVARCHAR -> DATE
UNICHAR, UNIVARCHAR -> TIME