SQL SERVER – Difference Between GETDATE and SYSDATETIME | Journey to SQL Authority with Pinal Dave

SQL SERVER – Difference Between GETDATE and SYSDATETIME | Journey to SQL Authority with Pinal Dave

瀏覽:1254
日期:2025-04-27
Until SQL Server 2005, there was only one function, GETDATE() which returns a DATETIME value. A DATETIME value has precision upto 3 milliseconds. SQL Server 2008 introduced a new data type DATETIME2 which gives precision upto 100 nanoseconds. But if ......看更多