SQL Server Education (by the geeks, for the geeks)
Many a times it is required to find working days between two dates. We do know that DATEDIFF function can be used to find differences between two dates; however the working …
Find working days between two dates in SQL Server Read MoreHi, Many a times need arises to get only date part from Datetime datatype/column/value. This blogs lists functions to get date from datetime in SQL Server. — SQL Server 2008 onwards …
Function to get date from datetime in SQL Server Read MoreA 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 MoreOne 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