sqlserver 中日期时间和时间戳的区别?

2021-12-10 00:00:00 time sql date sql-server

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 是 rowversion 的同义词 - 它是自动生成的，并且保证1是唯一的.datetime 不是 - 它只是一种处理日期和时间的数据类型，并且可以在插入等时由客户端指定.

According to the documentation, timestamp is a synonym for rowversion - it's automatically generated and guaranteed1 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.

1 当然，前提是你使用得当.查看评论.

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

相关文章