v.18.1Backward Incompatible Changes
Converting String '0' to DateTime Fails: Use '0000-00-00 00:00:00' Instead
Converting a string containing the number zero to DateTime does not work. Example:SELECT toDateTime('0'). This is also the reason thatDateTime DEFAULT '0'does not work in tables, as well as<null_value>0</null_value>in dictionaries. Solution: replace0with0000-00-00 00:00:00.