To support fine-grained time-based data, these date and time functions have been extended to support the microsecond date part and the abbreviations US and MCS:
DATEADD
DATECEILING
DATEDIFF
DATEFLOOR
DATENAME
DATEPART
DATEROUND
The data type conversion function CONVERT also supports five new format styles that include microsecond.
See Reference: Building Blocks, Tables, and Procedures > SQL Functions.
