curdate

Description

Syntax

DATE CURDATE()

Get the current date and return it in Date type

example

  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

CURDATE