>Hi,
>
>Could you please explain why (where is the rule?) the SQL Server always looks at the date in the following format: 'yyyyMMdd' (no matter the date format of the country where the SQL Server is installed).
>
>That is, the following code:
>

>DECLARE @SomeDate AS SmallDateTime
>SELECT @SomeDate = '20190204'
>SELECT @SomeDate
>

>
>always returns February 4th of 2019 (and NOT April 2nd).
>
>TIA

Read this blog and the article referenced in there

http://sqlblog.karaszi.com/is-yyyy-mm-dd-always-treated-as-year-month-date/