mysql返回当前日期的函数

返回当前日期：SELECT CURRENT_DATE()

返回当前时间：SELECT CURRENT_TIME()

返回当前日期和时间：SELECT CURRENT_TIMESTAMP()；

MySQL基础：网页链接

select adddate(''2014-08-01', numlist.id) as 'date' from (SELECT n1.i + n10.i*10 + n100.i*100 AS id FROM num n1 cross join num as n10 cross join num as n100) as numlist where adddate(''2014-08-01', numlist.id) <= '2014-09-01' 这样有效但是代码我看不懂。。。

---