![]() Returns a datetime value containing the date and time of the computer on which the instance of SQL Server runs. ![]() The returned value does not include the time zone offset. Lower-Precision System Date and Time Functions Function ![]() The function returns the date and time values as UTC time (Coordinated Universal Time). ![]() Returns a datetime2(7) value containing the date and time of the computer on which the instance of SQL Server is running. The returned value includes the time zone offset. Returns a datetimeoffset(7) value containing the date and time of the computer on which the instance of SQL Server runs. Returns a datetime2(7) value containing the date and time of the computer on which the instance of SQL Server runs. Use the GetSystemTimeAdjustment() Windows API to determine the accuracy. This API has a precision fixed at 100 nanoseconds. The accuracy depends on the computer hardware and version of Windows on which the instance of SQL Server running. SQL Server 2017 derives the date and time values through use of the GetSystemTimeAsFileTime() Windows API.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |