您现在的位置： 万盛学电脑网 >> 程序编程 >> 数据库 >> mysql教程 >> 正文
MySQL内置时间curdate查询用法
作者：佚名 责任编辑：admin 更新时间：2022-06-22
总结一下MySQL内置时间查询用法
mysql> SELECT year(curdate());
+-----------------+
| year(curdate()) |
+-----------------+
| 2009 |
+-----------------+
1 row in set (0.00 sec)
mysql> SELECT month(curdate());
+------------------+
| month(curdate()) |
+------------------+
| 8 |
+------------------+
1 row in set (0.00 sec)
mysql> SELECT day(curdate());
+----------------+
| day(curdate()) |
+----------------+
| 9 |
+----------------+
1 row in set (0.00 sec)
mysql> SELECT curdate();
+------------+
| curdate() |
+------------+
| 2009-08-09 |
+------------+
1 row in set (0.00 sec)
mysql> SELECT dayofmonth(curdate());
+-----------------------+
| dayofmonth(curdate()) |
+-----------------------+
| 9 |
+-----------------------+
1 row in set (0.00 sec)
- 上一个程序编程： mysql命令安装允许远程连接
- 下一个程序编程： 如何监控MySQL性能？
