(For reference: I worked on my company's ANSI Datetime implementation over 20 years ago, and the ANSI spec made it clear: using an invalid date (like A.D. 0) or an expression that yields an invalid date (e.g. "3/31/2017" - 1 UNITS MONTH) must always return an error and never just return wrong or garbage data.
(For reference: I worked on my company's ANSI Datetime implementation over 20 years ago, and the ANSI spec made it clear: using an invalid date (like A.D. 0) or an expression that yields an invalid date (e.g. "3/31/2017" - 1 UNITS MONTH) must always return an error and never just return wrong or garbage data.