Is number after DateTime2 is for nanosecond purpose?

4.1k Views Asked by At

I have read the document already but i do not fully understand The default precision is datetime2(7) is 7 represent the precision of nanosecond?

2

There are 2 best solutions below

0
On BEST ANSWER

The resolution of the default precision (7) for the datetime2 type is 100 nanoseconds.

An excellent reference for things date/time is: The ultimate guide to the datetime datatypes.

0
On

No, the number represents the number of digits preserved after the decimal point for the seconds. 3 would be millisecond, 6 microsecond and 7 equivalent to a precision of 100 nanoseconds.