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.
The CURRENT_TIMESTAMP function returns the current date and time as a datetime value. This value is derived from the operating system of the computer that the instance of SQL Server is running on.
This function is the ANSI SQL equivalent to the T-SQL GETDATE() function, so you can use whichever one you prefer. Note that both functions have a lower date range and a lower default fractional precision than the T-SQL SYSDATETIME() function (which returns a datetime2(7) value).
This article provides examples of the CURRENT_TIMESTAMP function, including how you can use it with other functions to return the value you’re interested in.
The GETDATE() function returns the current date and time as a datetime 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 GETDATE() function, including how you can use it with other functions to return the value you’re interested in.
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.