sqlserver中datetime和timestamp之间的区别？ [英] Difference between datetime and timestamp in sqlserver?

问题描述

code> Timestamp 和 Datetime SQL Server有什么区别？

What is the difference between Timestamp and Datetime SQL Server?

我认为这两种格式都能够存储日期+时间。那么，他们之间的区别在哪里？

I thought Both formats are capable of storing date + time. Then, Where the difference is lying between them?

但是 Timestamp 不能存储日期，时间信息。

But Timestamp is not capable of storing date, time information.

还有什么区别？

推荐答案

根据文档， timestamp 是$的同义词c $ c> rowversion - 它是自动生成的，保证 ¹ 是唯一的。 datetime 不是 - 它只是一种处理日期和时间的数据类型，可以在插入等上由客户指定。

According to the documentation, timestamp is a synonym for rowversion - it's automatically generated and guaranteed¹ to be unique. datetime isn't - it's just a data type which handles dates and times, and can be client-specified on insert etc.

¹ 当然，假设你正确使用它。查看评论。

¹ Assuming you use it properly, of course. See comments.

这篇关于sqlserver中datetime和timestamp之间的区别？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！