有没有在C#和DateTime在SQL Server日期时间有什么区别? [英] Is there any difference between DateTime in c# and DateTime in SQL server?
问题描述
喜
有没有在C#和DateTime在SQL Server日期时间有什么区别?
hi Is there any difference between DateTime in c# and DateTime in SQL server?
推荐答案
precision和范围(所以,一切都重要;-p)
Precision and range (so, everything important ;-p)
从MSDN:
DateTime值类型重新presents日期和时间与价值从午夜12:00:00,1月1日,0001公元(共同的时代)通过下午11:59:59不等,12月31日,公元9999( CE)
The DateTime value type represents dates and times with values ranging 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.)
时间值被称为蜱100毫微秒为单位,以及特定的日期是蜱的数量自午夜12:00,1月1日,在GregorianCalendar的月份牌公元0001(C.E.)
Time values are measured in 100-nanosecond units called ticks, and a particular date is the number of ticks since 12:00 midnight, January 1, 0001 A.D. (C.E.) in the GregorianCalendar calenda
日期范围:1753年1月1日,到9999年12月31
Date Range: January 1, 1753, through December 31, 9999
精度:四舍五入为.000,.003或0.007秒增量
Accuracy: Rounded to increments of .000, .003, or .007 seconds
这篇关于有没有在C#和DateTime在SQL Server日期时间有什么区别?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!