search

Home >Backend Development >PHP Tutorial > PHP查找一周内的数据 和一段范围的数据 如何写SQL

PHP查找一周内的数据 和一段范围的数据 如何写SQL

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB
WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOriginal
2016-06-13 12:43:08949browse

PHP查找一周内的数据 和一段范围的数据 怎么写SQL
字段是 时间戳的

网上搜索这样不行的
　7天

　　SELECT * FROM `表名` where DATE_SUB(CURDATE(), INTERVAL 7 DAY) 
　　/*DATEDIFF(now() , FROM_UNIXTIME(`时间字段名`)) = 7; //时间字段 存储类型为时间戳*/


$wheresql .=" AND datediff(now(),FROM_UNIXTIME(`paidan_time`))=7 ";

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： php中面向对象开发研讨 Next article： 关于php上传文件的有关问题

Related articles

See more