Re: just to laugh

Jim H <[email protected]> Sat, 29 Aug 2020 16:12:28 +0000

Newsgroups	comp.databases.mysql
Organization	Forte - www.forteinc.com
Message-ID	<[email protected]>

On Fri, 28 Aug 2020 14:38:56 -0000 (UTC), in
<[email protected]>, Ammammata
<[email protected]> 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

Why is the result above funny?

Hint before answering... the results aren't ISO week dates.
-- 
Jim H