How to select date and time without the seconds in mysql? December 19, 2023 by Tarik SELECT DATE_FORMAT(`date`, '%Y-%m-%d %H:%i') AS `formatted_date` FROM `table`;