Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

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?

like image 615
Sarawut Positwinyu Avatar asked Oct 12 '11 10:10

Sarawut Positwinyu


1 Answers

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.

like image 195
Martin Smith Avatar answered Sep 23 '22 11:09

Martin Smith