Home >Database >Mysql Tutorial >MySql截取DateTime字段的日期值_MySQL
MySql截取DateTime字段的日期值_MySQL
- WBOYOriginal
- 2016-06-01 13:01:51959browse
用 DATE_FORMAT 来格式化日期字段
SELECT DATE_FORMAT(crt_time,'%Y-%m-%d') FROM ad_n_advertise_t
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数据库插入语句之insertinto,replaceinto,insertignore_MySQLNext article：mysql插入Emoji表情报错_MySQL