MySQL/MariaDB - French date format conversion

How to convert a date in french format (DD/MM/YYYY) to US format (YYYY-MM-DD)

Example :
 
Select STR_TO_DATE('02/12/2017','%d/%m/%Y')

--> 2017-12-02