curdate

description

Syntax

DATE CURDATE()

获取当前的日期,以DATE类型返回

Examples

  1. mysql> SELECT CURDATE();
  2. +------------+
  3. | CURDATE() |
  4. +------------+
  5. | 2019-12-20 |
  6. +------------+
  7. mysql> SELECT CURDATE() + 0;
  8. +---------------+
  9. | CURDATE() + 0 |
  10. +---------------+
  11. | 20191220 |
  12. +---------------+

keyword

  1. CURDATE