date format

[mikerh9]

I have comlumn in mysql type datetime. I need to get the date in DATE fromat.
select DATE(reg_date) as test from a1;

It gives me an error.
How to select date in different date format?

[devinemke]

DATE_FORMAT

[mikerh9]

thanks