1

Topic: Datepart (week) - 2017

The calendar card on the Internet informs that ' 20170102 ' it is the first week of year. And DATEPART (wk, ' 20170102 ') that the second. Who is right and how them to reconcile?

2

Re: Datepart (week) - 2017

...Andrey...;
Looking how to consider. Depends DATEFIRST or there is other variant on Thursdays DATEPART (ISO_WEEK...)

3

Re: Datepart (week) - 2017

...Andrey...;
http://www.sql.ru/forum/1263475/nomer-nedeli

4

Re: Datepart (week) - 2017

Thanks for involvement