1DATE_FORMAT(date, format)
2-- E.g.
3SELECT DATE_FORMAT(dateField, '%m/%d/%Y') FROM TableName;
4-- See https://www.mysqltutorial.org/mysql-date_format/ for available formats
1 -- Convert the current date to YYYYMM format
2 SELECT DATE_FORMAT(NOW(), '%Y%m');
3 # 201302