c# - .net DateTime MaxValue 一旦存储在数据库中就不同了

Question

当我在数据库中存储值为 DateTime.MaxValue 的日期属性并将其取回时，存储的值不等于 DateTime.MaxValue。刻度属性已关闭。为什么是这样？

使用MS SQL，日期字段的数据类型是'datetime'

Answer 1

因为 SQL 日期时间的分辨率较低。

The DateTime data type in MS SQL represents Date and time data from January 1, 1753, to December 31, 9999, with an accuracy of one three-hundredth second, or 3.33 milliseconds. Values are rounded to increments of .000, .003, or .007 milliseconds.

source

The DateTime value type in .Net represents dates and times from 12:00:00 midnight, January 1, 0001 Anno Domini (Common Era) through 11:59:59 P.M., December 31, 9999 A.D. (C.E.) Time values are measured in 100-nanosecond units called ticks.

source