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 that DateTime DEFAULT '0' does not work in tables, as well as <null_value>0</null_value> in dictionaries. Solution: replace 0 with 0000-00-00 00:00:00.