字符串"/>
MySql取最近七天的日期字符串
SELECTDATE_FORMAT( date, '%Y-%m-%d' ) date
FROM(SELECT@s := @s + 1 AS `index`,DATE(DATE_SUB( CURRENT_DATE, INTERVAL @s DAY )) AS `date` FROMmysql.help_topic,(SELECT@s := - 1 ) temp WHERE@s < 6 ) a
ORDER BY`date` DESC
更多推荐
MySql取最近七天的日期字符串
发布评论