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 Functions
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
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
DIFFERENCE function in SQL Server
The DIFFERENCE() function returns an integer after comparing two SOUNDEX values. The integer number, ranging from 0 to 4, indicates the match between the two
Big Data & SQL 