Collections:
Difference Between GETDATE() and GETUTCDATE() in SQL Server
What Is the Difference Between GETDATE() and GETUTCDATE() in SQL Server Transact-SQL?
✍: FYIcenter.com
The difference between GETDATE() and GETUTCDATE() is time zone number of the SQL Server machine. The tutorial exercise below gives you a good example:
DECLARE @local_time DATETIME; DECLARE @gmt_time DATETIME; SET @local_time = GETDATE(); SET @gmt_time = GETUTCDATE(); SELECT 'Server local time: ' + CONVERT(VARCHAR(40),@local_time); SELECT 'Server GMT time: ' + CONVERT(VARCHAR(40),@gmt_time); SELECT 'Server time zone: ' + CONVERT(VARCHAR(40), DATEDIFF(hour,@gmt_time,@local_time)); GO Server local time: Jun 2 2007 10:06PM Server GMT time: Jun 2 2007 4:21PM Server time zone: 6
Note that the local time is from SQL server machine, not your local machine if you are connected to the server remotely. The local time is also adjusted by day-light savings.
⇒Date/Time Operations and Functions in SQL Server Transact-SQL
2017-02-14, 1795👍, 0💬
Popular Posts:
How To Start Instance with a Minimal Initialization Parameter File in Oracle? The sample initializat...
What are single-byte character string data types supported in SQL Server Transact-SQL? Single-byte c...
How To Round a Numeric Value To a Specific Precision in SQL Server Transact-SQL? Sometimes you need ...
What Are the Underflow and Overflow Behaviors on FLOAT Literals in SQL Server Transact-SQL? If you e...
What Are Logical/Boolean Operations in SQL Server Transact-SQL? Logical (Boolean) operations are per...