mysql SELECT year(curdate()); +—————–+ | year(curdate()) | +—————–+ | 2009 | +—————–+ 1 row in set (0.00 sec) mysql SELECT month(curdate()); +——————+ | month(curdate()) | +——————+
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)