search

Home >Database >Mysql Tutorial >Mysql的timestamp的查询_MySQL

Mysql的timestamp的查询_MySQL

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB
WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOriginal
2016-06-01 13:30:181229browse

bitsCN.com

Mysql的timestamp的查询

 

在mysql , 凡是以timestamp为类型的字段作为查询条件的都要做转换，如下:

 

DATE_FORMAT(`timestamp`,'%Y-%m-%d %H:%i:%s')>='2013-03-05 00:00:00'

 

 

我原来是这样处理： 

 

DATE(`timestamp`)>='2013-03-05 00:00:00'

 

 

结果发现，只列出03-06的数据出来，03-05有数据，但没显示，后来换成这样才行，

 

DATE_FORMAT(`timestamp`,'%Y-%m-%d %H:%i:%s')

 

 

各位，以后遇到这样的情况，注意一下

 

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：MMM的一个Bug_MySQLNext article：mysql表分区语句举例_MySQL

Related articles

See more