sqlserver 中日期时间和时间戳的区别? [英] Difference between datetime and timestamp in sqlserver?

问题描述

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 的同义词 - 它是自动生成的，并且保证¹是唯一的.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 中日期时间和时间戳的区别?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！