SELECT DATE(`date_time_field`) AS date_part, TIME(`date_time_field`) AS time_part FROM `your_table`;
//Also you can use:
SELECT DATE_FORMAT(colName,'%Y-%m-%d') DATEONLY,DATE_FORMAT(colName,'%H:%i:%s') TIMEONLY FROM `your_table`;
http://stackoverflow.com/questions/1233 ... e-in-mysql
[ view entry ] ( 1359 views ) | print article
<<First <Back | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | Next> Last>>