mysql+curdate+昨天_MySQL内置时间curdate查询用法

MySQL内置时间curdate查询用法

文章作者：网友投稿　发布时间：2010-08-15 10:02:19　来源：网络

总结一下MySQL内置时间查询用法 mysql SELECT year(curdate()); +-----------------+ | year(curdate()) | +-----------------+ | 2009 | +-----------------+ 1 row in set (0.00 sec) mysql SELECT month(curdate()); +------------------+ | month(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)