Home >Database >Mysql Tutorial >mysql时间戳分小时查询数据问题

mysql时间戳分小时查询数据问题

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB
WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOriginal
2016-06-06 09:34:251189browse

mysql时间戳数据库

现有数据库a,内有字段 shijian,格式为时间戳
如何分小时查询数据?不是查询某一天的,是所有的时间的
例如
shijian为0时的数据......
shijian为1时的数据......
..
..
shijian为22时的数据
shijian为24时的数据

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