Difference between datetime and timestamp in sqlserver? [duplicate]

by

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 Assuming you use it properly, of course. See comments.

More Related Contents:

  1. How to return only the Date from a SQL Server DateTime datatype
  2. Best approach to remove time part of datetime in SQL Server
  3. Get the week start date and week end date from week number
  4. How to determine the number of days in a month in SQL Server?
  5. How to convert an integer (time) to HH:MM:SS::00 in SQL Server 2008?
  6. Find closest date in SQL Server
  7. Query comparing dates in SQL
  8. SQL SERVER: Get total days between two dates
  9. SQL “between” not inclusive
  10. Date serial in SQL?
  11. Get the mentioned output by SQL query
  12. I need help formatting inner join command in SQL query
  13. Calculate a Running Total in SQL Server
  14. SQL transpose full table
  15. How to Create a real one-to-one relationship in SQL Server
  16. Select statement to find duplicates on certain fields
  17. Getting only Month and Year from SQL DATE
  18. How to store only time; not date and time?
  19. How to fetch the row count for all tables in a SQL SERVER database [duplicate]
  20. WHERE Clause vs ON when using JOIN
  21. Using a Variable in OPENROWSET Query
  22. SQL server ignore case in a where expression
  23. How To Create Table with Identity Column
  24. SQL Server LIKE containing bracket characters
  25. Alternate of lead lag function in SQL Server 2008
  26. DISTINCT for only one column
  27. How do I create and query linked database servers in SQL Server?
  28. Add emoji / emoticon to SQL Server table
  29. Perform regex (replace) in an SQL query
  30. What is the internal representation of datetime in sql server?

Leave a Comment