How to select only date from a DATETIME field in MySQL? November 22, 2022 by Tarik SELECT DATE(ColumnName) FROM tablename; More on MySQL DATE() function.