DateTime2 vs DateTime in SQL Server

by

The MSDN documentation for datetime recommends using datetime2. Here is their recommendation:

Use the time, date, datetime2 and
datetimeoffset data types for new
work. These types align with the SQL
Standard. They are more portable.
time, datetime2 and datetimeoffset
provide more seconds precision.
datetimeoffset provides time zone
support for globally deployed
applications.

datetime2 has larger date range, a larger default fractional precision, and optional user-specified precision. Also depending on the user-specified precision it may use less storage.

More Related Contents:

  1. Convert text to system date format [duplicate]
  2. How to return only the Date from a SQL Server DateTime datatype
  3. Best approach to remove time part of datetime in SQL Server
  4. SQL query to select dates between two dates
  5. How can I select the first day of a month in SQL?
  6. How can I convert bigint (UNIX timestamp) to datetime in SQL Server?
  7. How to compare datetime with only date in SQL Server
  8. Getting Dates between a range of dates
  9. How to get a particular preceding value of a column in SQL [closed]
  10. SQL where clause odd behavior [closed]
  11. How do I obtain a Query Execution Plan in SQL Server?
  12. How do I escape a single quote in SQL Server?
  13. What is the meaning of the prefix N in T-SQL statements and when should I use it?
  14. How important is the order of columns in indexes?
  15. Remove Identity from a column in a table
  16. Why no windowed functions in where clauses?
  17. Formatting Numbers by padding with leading zeros in SQL Server
  18. T-SQL Cast versus Convert
  19. convert Excel Date Serial Number to Regular Date
  20. For Nvarchar(Max) I am only getting 4000 characters in TSQL?
  21. Partition Function COUNT() OVER possible using DISTINCT
  22. How do I query for all dates greater than a certain date in SQL Server?
  23. Need to list all triggers in SQL Server database with table name and table’s schema
  24. Count based on condition in SQL Server
  25. Best equivalent for IsInteger in SQL Server
  26. Syntax of for-loop in SQL Server
  27. How to correctly insert newline in nvarchar [duplicate]
  28. How do you copy a record in a SQL table but swap out the unique id of the new row?
  29. Using IF ELSE statement based on Count to execute different Insert statements
  30. Group consecutive rows of same value using time spans

Leave a Comment