MySQL内置时间curdate查询用法
MySQL内置时间curdate查询用法
总结一下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)