sql server datetime vs datetime2

Solutions on MaxInterview for sql server datetime vs datetime2 by the best coders in the world

Search
showing results for - "sql server datetime vs datetime2"
Vincent
02 Aug 2020
1The MSDN documentation for datetime recommends using datetime2. Here is their recommendation:
2
3Use 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.
4
5datetime2 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.
source
similar questions
sql date between one weekdate diff sqlsql list dates between two datessql between date rangecheck if two date ranges overlap sql serversql datediff monthhow to get the date diff of 2 dates in the same fieldin sql serverdate difference in number of days sql serversql server query for datediffsql hours between two datesdate vs datetimesql get latest of 2 datetimesdifference in dates sqldifference between 2 query results sql serversql datediff hours and minutessql select between two datessql get number of days between two dateshow to get the date diff on once field in sql serversql server select between datetimefind difference in dates sqlhow to get number of months between 2 dates sql serversql check if date is between 2 datessql server datetime comparesql datediff db2
queries leading to this page
datetime vs datetime2 287 29 sql serverdatetime vs datetime2 vs date sql servert sql datetime vs datetime2datetime vs datetime2 287 29date vs datetime2 sqlsql server datetime2 vs datetimemssql datetime length setsql server difference between datetime and datetime2sql datetime2mssql time vs date vs datetime2sql differnces between datetime and datetime2sql server datetime2 vs timesql server datetime vs datetime2 vs timestamp tsql datetime vs datetime2sql server datetime vs datetime2sql datetime2 vs datetimesql server datetime2 287 29 vs datetimedatetime2 vs datetime sqlsql datetime vs datetime2db datetime vs datetime2datetime vs datetime2 sql serversql server datetime2datetime vs datetime2datetime2 ms sql betweensql server what is the difference between datetime and datetime2sql 2017 datetime2 vs datetimedatetime2datetime2 vs datetime in sql serversql datetime 2sql server date vs datetimesql server datatime 2sql datetime datetime2datetime2 3 vs datetime2 7 in sql servermssql datetime2 vs datetimesql server datetime2 vs datetimeoffsetdate vs datetime sql serverdatetime vs datetime2 in sql serverdatetime2 vs datetimesql server datetime or datetime2sql server datetime vs datetime2