TimePrecision
Set the default time precision for SQL scalar time functions.
Synopsis
n is an integer in the range 0—9. The default value is 0.
Description
TimePrecision defines the default number of decimal places in the value returned by the SQL scalar functions GETDATE(), CURRENT_TIME, CURRENT_TIMESTAMP, GETUTCDATE, and UNIX_TIMESTAMP. A value returned by these function has n decimal places for fractional seconds. The actual precision possible is platform dependant; precision digits in excess of the precision available on your system are returned as zeros.