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 Conversioan
DATE -> UNICHAR, UNIVARCHAR
TIME -> UNICHAR, UNIVARCHAR
UNICHAR, UNIVARCHAR -> DATE
UNICHAR, UNIVARCHAR -> TIME