Answers for "get date from datetime mysql"

how to get the date from datetime in mysql

SELECT DATE(ColumnName) FROM tablename;

Posted by: Guest on October-26-2021

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 "get date from datetime mysql"