Sql server datetime vs datetime2

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.

Source: stackoverflow.com

Similar codes

0 vote295 views1 answer
SQL Server format datetime
SQL
1 vote321 views1 answer
Select 2 rows in sql
SQL
0 vote314 views1 answer
Syntax for changing column size in mysql
SQL
2 votes372 views1 answer
Install postgresql centos 5
SQL
0 vote356 views1 answer
Query for backup a database at another location in file system
SQL
26 votes316 views2 answers
What is the sql statement that finds duplicate usernames
SQL
0 vote319 views1 answer
Drop constraint in ms sql
SQL
0 vote323 views1 answer
Alter rename command in mysql
SQL
0 vote320 views2 answers
How do I install microsoft SQL on my Mac?
SQL
10 votes403 views4 answers
Sql server pagination
SQL