select substr(Ann_CreateDate, 1, 10) createdate, news.* from `news` WHERE 1=1 ORDER BY Ann_SerialNo DESC