如何从mysql查询中提取日期和时间部分

I need to select a max(date) from a MySQL table and have each part of the date and time be in a separate variable. I need to select a max(date) from a MySQL table