Hello.
I have some rows in my database that contains some dates.
I need to select all dates based on a weeknumber, how is this possible?
+2
A:
The T-SQL DATEPART function will take week (abbreviated form wk) as its first parameter. This will do what you want. Reference here:
David M
2010-06-01 12:27:08
This helped me getting the right week number: http://stackoverflow.com/questions/348880/getting-week-number-off-a-date-in-ms-sql-server-2005
meep
2010-06-01 12:50:31
A:
select date from table_name where DATE_FORMAT(date, "%U-%Y")="11-2010"
where 11 is week number
and 2010 is year
Salil
2010-06-01 12:28:20