SELECT DATE(tablename.Date_variable, ISO)

SELECT (tablename.Date_variable AS DATE)

SELECT CHAR(CAST (tablename.Date_variable AS DATE), ISO)

ALL OF THEM