sql server french format date

Here is how we can get a YYYY-MM-DD date format, without the hours and minutes.

select CONVERT(VARCHAR(10), GetDate(), 120) as [myFrenchDate]