The DAY, MONTH, YEAR functions can be used to extract the day, month, and year from a date. These features are most commonly used in
Category: SQL Server
SQL Server Administration, Development and Maintenance
TIMEFROMPARTS in SQL Server
It may be necessary to integrate the several elements of the time into one. In such cases, SQL Server’s TIMEFROMPARTS function will come in handy.
SwitchOffset in SQL Server
The SWITCHOFFSET function returns a datetimeoffset value that has been altered from the stored time zone offset to a new time zone offset that has
Get Date In Multiple Formats in SQL Server
SQL Server has a number of built-in functions that can be used to retrieve the current date in various formats. The following is a list
SQL Server Mathematical Functions-2
For the previous post, click here. As stated earlier, mathematical Functions are built-in scalar functions that perform calculations depending on input values provided as arguments
SQL Server Mathematical Functions-1
Mathematical Functions are built-in scalar functions that perform calculations depending on input values provided as arguments and return a numeric value. We’ll go through the
Big Data & SQL 