sql - DateTime2与SQL Server中的DateTime(DateTime2 vs DateTime in SQL Server)

Question

Which one:

(哪一个：)

• datetime
• datetime2

is the recommended way to store date and time in SQL Server 2008+?

(是在SQL Server 2008+中存储日期和时间的推荐方法吗？)

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?

(我知道精度（和存储空间可能）的差异，但暂时忽略这些，是否有关于何时使用什么的最佳实践文档，或者我们应该只使用datetime2 ？)

  ask by Mikeon translate from so

Answer 1

The MSDN documentation for datetime recommends using datetime2 .

(datetime的MSDN文档建议使用datetime2 。)

Here is their recommendation:

(以下是他们的建议：)

Use the time , date , datetime2 and datetimeoffset data types for new work.

(使用time ， date ， datetime2和datetimeoffset数据类型进行新工作。)

These types align with the SQL Standard.

(这些类型与SQL标准一致。)

They are more portable.

(它们更便携。)

time , datetime2 and datetimeoffset provide more seconds precision.

(time ， datetime2和datetimeoffset提供更多的秒精度。)

datetimeoffset provides time zone support for globally deployed applications.

(datetimeoffset为全局部署的应用程序提供时区支持。)

datetime2 has larger date range, a larger default fractional precision, and optional user-specified precision.

(datetime2具有更大的日期范围，更大的默认小数精度和可选的用户指定精度。)

Also depending on the user-specified precision it may use less storage.

(此外，根据用户指定的精度，它可能使用较少的存储空间。)