Home >Database >Mysql Tutorial >MySql用DATE_FORMAT截取DateTime字段的日期值
MySql用DATE_FORMAT截取DateTime字段的日期值
- WBOYOriginal
- 2016-06-07 16:28:501005browse
用 DATE_FORMAT 来格式化日期字段 SELECT DATE_FORMAT(crt_time,'%Y-%m-%d') FROM ad_n_advertise_t
用 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：浅谈sql数据库去重Next article：mysql5.6.19下子查询为什么无法使用索引