sql set the week number start

Question

This statement gives me the number of the current week starting from the 1st of january

select datepart(week,getdate())

I would like the calculation to be done starting from 1st november.
Is there a way I can accomplish this?
I know the date first method can pick the day the week starts etc.

please tag DBMS and show input and desired output – Sateesh Pagolu Sep 04 '15 at 09:09 — Sateesh Pagolu, Sep 04 '15 at 09:09

score 0 · Accepted Answer · answered Sep 04 '15 at 09:33

0

You may looking for DateDiff

select DATEDIFF(week, '1-Nov-2014', GETDATE()) + 1
OutPut: 45

answered Sep 04 '15 at 09:33

Praveen

8,945
4
31
49

sql set the week number start

1 Answers1