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, 1422👍, 0💬
Popular Posts:
Where to find answers to frequently asked questions on INSERT, UPDATE and DELETE Statements in MySQL...
Can Date and Time Values Be Converted into Integers in SQL Server Transact-SQL? Can date and time va...
How To Change the Password for Your Own User Account in MySQL? If you want to change the password of...
What is SQL Server Transact-SQL (T-SQL)? SQL Server Transact-SQL, also called T-SQL, is an extension...
Where to find SQL Server database server tutorials? Here is a collection of tutorials, tips and FAQs...