Home >Database >Mysql Tutorial >深入mysql YEAR() MONTH() DAYOFMONTH()日期函数的详解_MySQL
深入mysql YEAR() MONTH() DAYOFMONTH()日期函数的详解_MySQL
- WBOYOriginal
- 2016-06-01 13:25:011839browse
bitsCN.com
mysql的日期函数. 例子中当前日期：
curdate() 是2013年6月24日。
YEAR() ：显示年
mysql> select year(curdate()); +-----------------+ | year(curdate()) | +-----------------+ | 2013 | +-----------------+ 1 row in set (0.01 sec)
MONTH() ：显示月
mysql> select month(curdate()); +------------------+ | month(curdate()) | +------------------+ | 6 | +------------------+ 1 row in set (0.00 sec)
DAYOFMONTH()：显示日期
mysql> select dayofmonth(curdate()); +-----------------------+ | dayofmonth(curdate()) | +-----------------------+ | 24 | +-----------------------+ 1 row in set (0.08 sec)
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：MySQL essential版本和普通版本有什么区别？_MySQLNext article：分享下mysql各个主要版本之间的差异_MySQL