>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
It is "canonical ODBC format". Should be declared in some ODBC proposal.