In Part 2 of working with dates we use the INT, DAY and WEEKDAY functions to derive the week number within a month for a given date. The following screen shot shows the desired results, assuming a week starts on a Monday:
Wednesday 1st June 2011 is in week 5 of the previous month (May) as the Monday of that week was ion the previous month.
Monday 6th June is in week 1 as it is the first Monday of June.
The following screen shot shows an Excel workbook containing a column (A) of dates from which we extract the first and last dates of the month of these dates:
In Part 2 of our “SQL Server - Working With Dates” blog we use the DATEPART function.
DATEPART works in the same way as DATENAME, but returns numbers for the weekday and month instead of the word. (weekdays start with 1 for Sunday by default, but this can be changed).
The following example shows a comparison of DATENAME and DATEPART:
Ian & I have received a lot of queries from past delegates about handling various date challenges when extracting data from SQL Server and Oracle databases, so we are adding them to our blog for your reference. There will be a series of posts and this is Part 1.
The following examples are for SQL Server, and are based on the AdventureWorks2014 sample database.
The following queries uses the DATENAME and DATEADD functions.
DATENAME can be used to extract a specified part of a date/time value. It takes two arguments:
