Differences

This shows you the differences between two versions of the page.

sql-server:datetime_or_datetime2_3 [December 29, 2017 2:48 am]
sqlines
sql-server:datetime_or_datetime2_3 [December 29, 2017 2:49 am] (current)
sqlines
Line 83: Line 83:
During migration you may want to utilize the maximum DATETIME2 precision and convert datetime data types to DATETIME2(7) rather than DATETIME2(3). During migration you may want to utilize the maximum DATETIME2 precision and convert datetime data types to DATETIME2(7) rather than DATETIME2(3).
-Sometimes it can cause problems, for example, if there is a user-defined function or application logic that expects milliseconds at the specified position:+Sometimes it can cause problems, for example, if there is a user-defined function or application logic that expects milliseconds at the specified position after conversion to string:
<code sql> <code sql>