search

Home >Database >Mysql Tutorial >MYSQL截取日期格式　年,月,日_MySQL

MYSQL截取日期格式　年,月,日_MySQL

WBOY
WBOYOriginal
2016-06-01 13:26:071790browse

bitsCN.com

MYSQL 截取日期格式　年,月,日

select DATE_FORMAT(produceDate, '%Y') as yeahr from historybarcodesort where DATE_FORMAT(produceDate, '%Y')='2013'

返回结果:2013

bitsCN.com
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通过查看跟踪日志跟踪执行的sql语句_MySQLNext article：Mysql实现分区功能（一）_MySQL

Related articles

See more