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. +------------+

8. mysql> SELECT CURDATE() + 0;
9. +---------------+
10. | CURDATE() + 0 |
11. +---------------+
12. |      20191220 |
13. +---------------+

keyword

CURDATE