This article is tagged with:
Sql to char function with date
and mysql
sql to char function with date
SELECT
  TO_CHAR( sysdate, 'YYYY-MM-DD' )
FROM
  dual;