问题描述
哪一个:
datetime
datetime2
是推荐的方式来存储SQL Server 2008 +中的日期和时间?
is the recommended way to store date and time in SQL Server 2008+?
我是意识到精度差异(和存储空间可能),但是现在忽略这些差异,是否有一个最佳实践文档,说明何时使用什么,或者也许我们应该使用 datetime2
I'm aware of differences in precision (and storage space probably), but ignoring those for now, is there a best practice document on when to use what, or maybe we should just use datetime2
only?
推荐答案
MSDN文档建议使用。这是他们的建议:
The MSDN documentation for datetime recommends using datetime2. Here is their recommendation:
datetime2具有较大的日期范围,较大的默认分数精度和可选的用户指定精度。同样取决于用户指定的精度,它可能会使用较少的存储空间。
datetime2 has larger date range, a larger default fractional precision, and optional user-specified precision. Also depending on the user-specified precision it may use less storage.
这篇关于DateTime2与SQL Server中的DateTime的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!