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:
⇒ Verify Time Precision in SQL Server Transact-SQL
⇐ Date/Time Data Type Comparison in SQL Server Transact-SQL
⇑ Date/Time Operations and Functions in SQL Server Transact-SQL
2017-02-25, 1606🔥, 0💬
Popular Posts:
How REAL and FLOAT Literal Values Are Rounded in SQL Server Transact-SQL? By definition, FLOAT(n) sh...
Where to find answers to frequently asked questions on Transaction Management: Commit or Rollback in...
How to continue to the next iteration of a WHILE loop in SQL Server Transact-SQL? How to use CONTINU...
How To Change the Password for Your Own User Account in MySQL? If you want to change the password of...
Where to find Oracle database server tutorials? Here is a collection of tutorials, tips and FAQs for...