Default time precision for SQL scalar time functions.
The value n
is the default time precision for the Time component of the value returned by the SQL Scalar functions GETDATE(), CURRENT_TIME, and CURRENT_TIMESTAMP. The precision is expressed as the number of decimal places allowed for the millisecond portion of the time value.
Range of Values
09. The default is 0, which means milliseconds are not returned in the time value.