$ select version(); | version() | 5.2.24-log |
    | | —- | —- | —- | | current_date
    curdate() | 2014-01-31 |
    | | now() | 2014-01-31 22:16:18 |
    | | user() | odbc@localhost |
    | | year(current_date)
    year(curdate()) | 2014 |
    | | right(curdate(),5) | 02-01 |
    | | month(curdate()) | 2 |
    | | dayofmonth(curdate()) | 1 | 一个月中的第几天 | | MONTH(DATE_ADD(CURDATE(),INTERVAL 1 MONTH))
    MOD(MONTH(CURDATE()), 12) + 1 | 3 | 下个月 | | datebase() | test | 数据库 |