MYSQL截取日期格式 年,月,日_MySQL
- WBOYOriginal
- 2016-06-01 13:26:071756browse
bitsCN.com
MYSQL 截取日期格式 年,月,日
select DATE_FORMAT(produceDate, '%Y') as yeahr from historybarcodesort where DATE_FORMAT(produceDate, '%Y')='2013'
返回结果:2013
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