{"id":18,"date":"2011-06-28T04:32:23","date_gmt":"2011-06-28T04:32:23","guid":{"rendered":"https:\/\/sqlserverlearner.azurewebsites.net\/2011\/06\/28\/retreive-current-date-time-getdate-sysdatetime-sysdatetimeoffset-sysutcdatetime-current_timestamp-getutcdate\/"},"modified":"2011-06-28T04:32:23","modified_gmt":"2011-06-28T04:32:23","slug":"retreive-current-date-time-getdate-sysdatetime-sysdatetimeoffset-sysutcdatetime-current_timestamp-getutcdate","status":"publish","type":"post","link":"https:\/\/sqlserverlearner.com\/2011\/06\/28\/retreive-current-date-time-getdate-sysdatetime-sysdatetimeoffset-sysutcdatetime-current_timestamp-getutcdate\/","title":{"rendered":"Fetch current date time in SQL Server"},"content":{"rendered":"<p><strong>SQL SERVER CURRENT DATE TIME<\/strong><\/p>\n<p>How To Retrieve The Current Date Time in SQL Server?<\/p>\n<p>There are many in built functions provided by the SQL Server which can be used to fetch the current date time.<br \/>\nThe date time that is fetched by these functions would be the date time of the server on which the SQL Server is installed. The time zone also corresponds to the Server On which the SQL Server is installed.<\/p>\n<p>In order to fetch the current date time in SQL server the following Date and Time Functions can be used:<\/p>\n<ul>\n<li>SYSDATETIME ()<\/li>\n<li>SYSDATETIMEOFFSET()<\/li>\n<li>SYSUTCDATETIME()<\/li>\n<li>CURRENT_TIMESTAMP<\/li>\n<li>GETDATE()<\/li>\n<li>GETUTCDATE()<\/li>\n<li> {fn NOW()}<\/li>\n<\/ul>\n<p><span style=\"font-family: Times New Roman;font-size: small\"> <\/span><span style=\"font-family: Times New Roman;font-size: small\"> <\/span><span style=\"font-family: Times New Roman;font-size: small\"> <\/span><span style=\"font-family: Times New Roman;font-size: small\"> <\/span><span style=\"font-family: Times New Roman;font-size: small\"> <\/span><span style=\"font-family: Times New Roman;font-size: small\"> <\/span><span style=\"font-family: Times New Roman;font-size: small\"> <\/span><\/p>\n<p><strong>Advanced Details:<\/strong><\/p>\n<p>All the above functions use the windows API <strong>GetSystemTimeAsFileTime()<\/strong> to fetch the current data time. The precision for this API is fixed to ~100 Nano seconds.<\/p>\n<p>Date time Functions <strong>SYSDATETIME (), SYSDATETIMEOFFSET(), SYSUTCDATETIME()<\/strong> are high precition functions and the functions <strong>CURRENT_TIMESTAMP, GETDATE(), GETUTCDATE()<\/strong>are low precision functions.<\/p>\n<p>All the above functions have the same output in the query analyzer as shown in the below image:<\/p>\n<figure id=\"attachment_142\" aria-describedby=\"caption-attachment-142\" style=\"width: 199px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/sqlserverlearner.com\/wp-content\/uploads\/2011\/06\/datetimefunctionsqueryanalyzer.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-142\" title=\"datetime functions sql queryanalyzer\" src=\"\/wp-content\/uploads\/2011\/06\/datetimefunctionsqueryanalyzer-199x300.png\" alt=\"datetime functions sql queryanalyzer\" width=\"199\" height=\"300\"><\/a><figcaption id=\"caption-attachment-142\" class=\"wp-caption-text\">datetime functions sql queryanalyzer<\/figcaption><\/figure>\n<p>This means using any of the above functions has the same performance impact.<\/p>\n<p>Simply speaking, In order to get a high precision date time value then the function <strong>SYSDATETIME () <\/strong>can be used and for low precision date time value the function <strong>GETDATE() <\/strong>can be used.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>SQL SERVER CURRENT DATE TIME How To Retrieve The Current Date Time in SQL Server? There are many in built functions provided by the SQL Server which can be used to fetch the current date time. The date time that is fetched by these functions would be the date time of the server on which&hellip;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[66,41],"tags":[67,68,69,70,71,72,73,74,75,76],"class_list":["post-18","post","type-post","status-publish","format-standard","hentry","category-sql-date-time-functions","category-sql-server-basics","tag-date-time-functions-in-sql-server","tag-datetime-in-sql-server","tag-fetch-current-date-time-sql-server","tag-high-precition-date-time-functions-sql-server","tag-how-to-use-getdate-sql-server","tag-how-to-use-sysdatetime-sql-server","tag-low-precition-date-time-functions-sql-server","tag-retreving-current-date-time","tag-sql-server-current-date","tag-useful-date-time-functions-sql-server"],"_links":{"self":[{"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/posts\/18","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/comments?post=18"}],"version-history":[{"count":0,"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/posts\/18\/revisions"}],"wp:attachment":[{"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/media?parent=18"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/categories?post=18"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/tags?post=18"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}