SQL function to get weekday – weekly calendar
In this blog post we’ll look at a way to list out all week days of a week a particular date belongs too. This can be even referred to as weekly …
SQL function to get weekday – weekly calendar Read MoreTag: DATEPART
SET DATEFIRST in SQL Server
The SET DATEFIRST function is used to set the first day of the week from number 1-7. In order to know the current first day of the week, @@DATEFIRST is used. …
SET DATEFIRST in SQL Server Read MoreFunction to Extract Month from Date in SQL Server
A function to extract month from date is a most common question in forums. Month part from a date can be extracted as shown below SELECT MONTH(GETDATE()) AS [Month] GO SELECT …
Function to Extract Month from Date in SQL Server Read MoreSQL Function to Extract Year from Date
One of the most asked questions in forums and discussion board is how a SQL function to extract year from date. This can be done in multiple ways as shown below. …
SQL Function to Extract Year from Date Read More