Collections:
Get System Date and Time in SQL Server Transact-SQL
How to get system date and time in SQL Server Transact-SQL? I want a list of functions for getting current system date and time.
✍: FYIcenter.com
Here is a comparison of all functions that you can use
to get the current date and time from the data base server system:
Function Return type Precision ------------------- ----------------- ----------- SYSDATETIME() DATETIME2(7) 0.0000001 s SYSDATETIMEOFFSET() DATETIMEOFFSET(7) 0.0000001 s SYSUTCDATETIME() DATETIME2(7) 0.0000001 s CURRENT_TIMESTAMP DATETIME 0.00333 s GETDATE() DATETIME 0.00333 s GETUTCDATE() DATETIME 0.00333 s
Things to remember with selecting the get system date and time functions:
⇒Date/Time Operations and Functions in SQL Server Transact-SQL
2017-02-25, 909👍, 0💬
Popular Posts:
What Is a Parameter File in Oracle? A parameter file is a file that contains a list of initializatio...
Can You Create a View with Data from Multiple Tables in SQL Server? Can You Create a View with Data ...
How To Concatenate Two Text Values in Oracle? There are two ways to concatenate two text values toge...
How do you know if SQL Server is running on your local system in SQL Server? After installing SQL Se...
What Is the Difference Between GETDATE() and GETUTCDATE() in SQL Server Transact-SQL? The difference...