This isn't a dealbreaker, by any means – but I'm curious why ColumnStore restricts the range by 400 years?
A date and time combination. Supported range is 1400-01-01 00:00:00 to 9999-12-31 23:59:59.
That differs from MySQL 5.5+ which supports
The DATETIME type is used for values that contain both date and time parts. MySQL retrieves and displays DATETIME values in 'YYYY-MM-DD HH:MM:SS' format. The supported range is '1000-01-01 00:00:00' to '9999-12-31 23:59:59'.
ColumnStore reports (when attempting a value out of range):