Answers for "how to get date from datetime in mysql"

get date from timestamp in mysql

SELECT DATE_FORMAT('2013-11-26 01:24:34', '%Y-%m-%d');
> 2013-11-26

Posted by: Guest on July-20-2021

mysql get date from datetime

WHERE DATE(datetime) = '2009-10-20'

Posted by: Guest on April-29-2020

Code answers related to "how to get date from datetime in mysql"