The SYSDATETIME() function returns the current date and time as a datetime2(7) value. This value is derived from the operating system of the computer that the instance of SQL Server is running on.
This article provides examples of the SYSDATETIME() function, including how you can use it with other functions to return the value you’re interested in.
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.
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.
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.
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.
In SQL Server, the DATETIMEFROMPARTS() function works just like the DATEFROMPARTS() function, except that it also returns the time portion of the date.
The DATETIMEFROMPARTS() function accepts seven arguments, each representing a different part of the date/time. The function then returns a datetime value from the given parts.
You can use the T-SQL DATEFROMPARTS() function in SQL Server to return a date value that maps to the date parts that you provide as integer expressions.
The way it works is, you provide three values (one for each of the year, month, and day values), and SQL Server will return a date value based on the values you provide.
Examples below.
You can use ODBC scalar functions when running T-SQL statements in SQL Server. There are various types of ODBC scalar functions, including string functions, numeric functions, system functions, and of course, date/time functions (also referred to as date, time, and interval functions).
Below are examples of the date, time and interval functions you can use in SQL Server.
SYSUTCDATETIME() and GETUTCDATE() are two T-SQL date/time functions available for use in SQL Server. These functions return the date and time of the computer on which the instance of SQL Server is running. Both functions return the date and time as UTC time (Coordinated Universal Time).
So, both functions do the same thing. Almost.
Here’s how these two functions differ:
GETUTCDATE() returns its value as a datetime value.SYSUTCDATETIME() returns its value as a datetime2 value.This means that SYSUTCDATETIME() provides more seconds precision. The datetime2 data type also has a larger range than datetime.
SQL Server has a bunch of functions that return the current date/time. Two of these are the GETDATE() and SYSDATETIME() functions.
At first glance, these two functions appear to do the same thing – get the current date and time from the operating system of the computer on which the instance of SQL Server is running.
However, there’s a subtle difference between the two.