Equivalent of Datetime2 of mysql in mssql

Question

what is the equivalent of Datetime2 of mysql in mssql ?

Answer 1

MySQL 5.7 has fractional seconds support for TIME, DATETIME, and TIMESTAMP values, with up to microseconds (6 digits) precision: https://dev.mysql.com/doc/refman/5.7/en/fractional-seconds.html

Datetime2 Precision, scale 0 to 7 digits, with an accuracy of 100ns. The default precision is 7 digits https://learn.microsoft.com/en-us/sql/t-sql/data-types/datetime2-transact-sql

Datetime2 is a term used in MS SQL Server. A MS SQL Server column defined as datetime2(6) is the equivalent to a MySQL 5.7 datetime or timestamp column.