sql-server-2008datetime2

Is number after DateTime2 is for nanosecond purpose?

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?

Solution

  • 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.