摘要:
下文讲述mysql数据库中CURDATE函数的功能简介说明,如下所示;
curdate()函数功能说明
curdate()函数的功能:
返回当前日期的“YYYY-MM-DD”或“YYYYMMDD”格式的数值
curdate()函数示例说明
mysql> SELECT CURDATE();
+---------------------------------------------------------+
| CURDATE() |
+---------------------------------------------------------+
| 2020-08-10 |
+---------------------------------------------------------+
1 row in set (0.00 sec)
mysql> SELECT CURDATE() + 0;
+---------------------------------------------------------+
| CURDATE() + 0 |
+---------------------------------------------------------+
| 20200810 |
+---------------------------------------------------------+
1 row in set (0.00 sec)