Get only date from mysql datetime column

[ghjk]

My mysql database has datetime field and i want to get only date. how can i do that?

[code green]

SELECT CAST(`datetime_field` AS DATE) AS dateonly FROM etc...

[ghjk]

SELECT CAST(`datetime_field` AS DATE) AS dateonly FROM etc...

Thanks. It is working !