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