just to laugh

Ammammata <[email protected]> Fri, 28 Aug 2020 14:38:56 -0000 (UTC)
Newsgroups comp.databases.mysql
Organization solani.org
Message-ID <[email protected]>
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


-- 
/-\ /\/\ /\/\ /-\ /\/\ /\/\ /-\ T /-\
-=- -=- -=- -=- -=- -=- -=- -=- - -=-
........... [ al lavoro ] ...........