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
2
3
4
5 CREATE TABLE people (
6 id INT AUTO_INCREMENT PRIMARY KEY,
7 first_name VARCHAR(50) NOT NULL,
8 last_name VARCHAR(50) NOT NULL,
9 birth_date DATE NOT NULL
10);