SET DATESTYLE TO 'European'; in MySQL
mysql store all the dates in the same style. Internally this is three bytes that are expanded to the YYYY-MM-DD. You can convert this format to the any desired form by DATE_FORMAT() function like that: 

SELECT DATE(now()) AS sysformat
     , DATE_FORMAT( NOW(), '%W %M %D %Y, %j\'th day of the year') AS myformat