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, 1596🔥, 0💬
Popular Posts:
How To Find Out What Privileges a User Currently Has in Oracle? Privileges granted to users are list...
What Is ISAM in MySQL? ISAM (Indexed Sequential Access Method) was developed by IBM to store and ret...
How To Convert Characters to Numbers in Oracle? You can convert characters to numbers by using the T...
Can Date and Time Values Be Converted into Integers in SQL Server Transact-SQL? Can date and time va...
How to download and install the scaled-down database AdventureWorksLT in SQL Server? If you want to ...