CODEWITHSUNDEEP
sql-server-2008datetime2
Sarawut Positwinyu
Sarawut Positwinyu

Reputation: 5042

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?

Upvotes: 9

Views: 4218

Answers (2)

Mitch Wheat
Mitch Wheat

Reputation: 300489

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.

Upvotes: 7

Martin Smith
Martin Smith

Reputation: 452947

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.

Upvotes: 12

Related Questions