MySQL內置時間curdate查詢用法
來源：程序員人生 發布時間：2014-04-21 17:41:12 閱讀次數：4360次
總結一下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)
生活不易，碼農辛苦
如果您覺得本網站對您的學習有所幫助,可以手機掃描二維碼進行捐贈
