In SQL Server, the T-SQL SYSUTCDATETIME() function is used to return the current UTC time (Coordinated Universal Time). UTC time is the primary time standard by which the world regulates clocks and time.

The return value of the SYSUTCDATETIME() function is derived from the computer on which the instance of SQL Server is running. The time zone is not included, and it is returned as a datetime2 value. The fractional second precision specification has a range from 1 to 7 digits. The default precision is 7 digits.

SYSUTCDATETIME() does the same thing that GETUTCDATE() does, except that it returns a higher fractional precision. As mentioned,  SYSUTCDATETIME() returns a datetime2 value, whereas the GETUTCDATE() function returns a datetime value.

Continue reading →

When using SQL Server, you can use the T-SQL GETUTCDATE() function to return the current UTC time (Coordinated Universal Time). UTC time is the primary time standard by which the world regulates clocks and time.

The return value of the GETUTCDATE() function is derived from the computer on which the instance of SQL Server is running. The time zone is not included, and it is returned as a datetime value.

Continue reading →

In SQL Server, the transact-sql SYSDATETIMEOFFSET() function returns a datetimeoffset(7) value that contains the date and time of the computer on which the instance of SQL Server is running. This value includes the time zone offset.

Examples of usage below.

Continue reading →

The T-SQL TIMEFROMPARTS() function enables you to build a time value from the various time parts. You can also specify the precision of the return value.

Below are examples of how this function works.

Continue reading →

You can use the T-SQL SMALLDATETIMEFROMPARTS() function in SQL Server to return a smalldatetime value from the various date/time parts.

This article provides examples of usage, as well as cases where you can get an error or null value.

Continue reading →

T-SQL has a function called DATETIMEOFFSETFROMPARTS() that allows you to get a datetimeoffset value from the various separate parts of a date. Specifically, it returns a datetimeoffset value for the specified date and time and with the specified offsets and precision.

Examples of this function below.

Continue reading →

In SQL Server, the DATETIME2FROMPARTS() function works similar to the DATETIMEFROMPARTS() function, except that it accepts 8 arguments and returns a datetime2 value. The DATETIMEFROMPARTS() function on the other hand, accepts just 7 arguments and it returns a datetime value.

Basically, you provide all the date/time parts and this function will return a datetime2 value based on the parts you provide.

Continue reading →