OT weekdates in MSSQL [Re: just to laugh]

On 28-8-2020 16:38, Ammammata wrote:
> tried this with MS SQL
> 
> select DATEPART(wk, '20210101')
> select DATEPART(wk, '20210102')
> select DATEPART(wk, '20210103')
> select DATEPART(wk, '20210104')
> select DATEPART(wk, '20210105')
> select DATEPART(wk, '20210106')
> 
> result
> 
> 1
> 1
> 2
> 2
> 2
> 2
> 
> https://en.wikipedia.org/wiki/ISO_8601#Week_dates
> 
> 

select DATEPART(isowk, '20210101')
select DATEPART(isowk, '20210102')
select DATEPART(isowk, '20210103')
select DATEPART(isowk, '20210104')
select DATEPART(isowk, '20210105')
select DATEPART(isowk, '20210106')

result

53
53
53
1
1
1

https://docs.microsoft.com/en-us/sql/t-sql/functions/datepart-transact-sql?view=sql-server-ver15