2020-11-09

C#.Net与SQLServer时间范围的最小值最大值

C#.Net Framewrok:

DateTime.MinValue = 0001/01/01 00:00:00

DateTime.MaxValue = 9999/12/31 23:59:59.999 

SqlDateTime.MinValue.Value = 1753/01/01 00:00:00 

SqlDateTime.MaxValue.Value = 9999/12/31 23:59:59.997

 

SQL Server 2005:

DateTime 最小值 = 1753/01/01 00:00:00

DateTime 最大值 = 9999/12/31 23:59:59.997 

SmallDateTime 最小值 = 1900/01/01 00:00:00

SmallDateTime 最大值 = 2079.6.6

原文转载:http://www.shaoqun.com/a/489528.html

亿恩网:https://www.ikjzd.com/w/1461

patpat:https://www.ikjzd.com/w/1079.html

kk馆:https://www.ikjzd.com/w/1713


C#.NetFramewrok:DateTime.MinValue=0001/01/0100:00:00DateTime.MaxValue=9999/12/3123:59:59.999SqlDateTime.MinValue.Value=1753/01/0100:00:00SqlDateTime.MaxValue.Value=9999/12/3123:59:59.997SQLServer2005:
旺店通:https://www.ikjzd.com/w/2390
雨果:https://www.ikjzd.com/w/1307
鼓浪屿沙茶面哪里的比较好吃?:http://tour.shaoqun.com/a/43410.html
成都武侯祠游览须知 :http://tour.shaoqun.com/a/17514.html
思考|中美经贸关系的下一步是什么?:https://www.ikjzd.com/home/114931

No comments:

Post a Comment