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 ] ...........