Popular Posts

SQLblog.com - The SQL Server blog spot on the web

Wednesday, October 4, 2017

Getting the same value in last 3 or digits when using Datetime2 data type in SQL Server 2012

SQLServerCentral » Latest topics
Getting the same value in last 3 or digits when using Datetime2 data type in SQL Server 2012
I recently started to use datetime2 data type in SQL Server 2012, and found something interesting.  The time value in last 3 or 4 digits tends to be the same. See my data sample below, and they all ended at 5911. The value was retrieved using sysdate

No comments: