get week of a date sql code example

Example 1: sql server week number

datepart(wk, DateToParse)

Example 2: datepart day of week

SELECT DATENAME(DW,'2007-10-30');