Convert datetime value into string June 8, 2023 by Tarik Use DATE_FORMAT() SELECT DATE_FORMAT(NOW(), '%d %m %Y') AS your_date;