Community Learn Tools Library Leisure
search
English
Home > Backend Development > PHP Tutorial > body text

求一段查询sql

WBOY
Release： 2016-06-23 13:26:10
Original
874 people have browsed it

数据库表有一个字段create_time，类型是int(10) ，存储的是对应的时间戳。
这个数据表已经存放了一年多的数据了

现在我要查询：create_time字段每天下午14:00到20:00的所有记录，请问这个sql应该怎么写？


回复讨论(解决方案)

select * from 表 where FROM_UNIXTIME(create_time, '%H:%i') BETWEEN ‘14:00' and '20:00'

不建议数据库里存unix时间戳，像你这个业务就必须用到函数，执行效率会下降

select * from 表 where FROM_UNIXTIME(create_time, '%H:%i') BETWEEN ‘14:00' and '20:00'



between and可以对14:00到20:00的值进行比较？
学习了。感谢！

不建议数据库里存unix时间戳，像你这个业务就必须用到函数，执行效率会下降



这个我知道，但是没办法，这个是新加出来的业务，而且我还不能修改数据结构，如果可以，我想增加一个int字段，将时间段以分钟为单位或者以秒为单位分割成类似1~2359这样的不同类型，这样查询起来肯定最快
Related labels：
求一段查询sql
source：php.cn
Previous article：小蚂蚁学习PHP性能优化（1） Next article：变量与常量
Statement of this Website
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
Latest Articles by Author
Latest Issues
Calculate the sum of fields in another table using MySQL SQL query I have a schema like this: User table with attributes "user_id" and "userna...
From 2024-04-06 19:39:29
0
1
441
Record query under partial value conditions - SQL skill sharing I have a table called zipcode which has a column called code. The Code column contains the...
From 2024-04-06 16:01:26
0
1
395
MySQL issues when summarizing sales data from two separate tables Thank you very much in advance for your support. I'm learning SQL and generating some data...
From 2024-04-04 14:22:13
0
2
343
A single SQL query that will use one SELECT result in the next subquery in the same request I'm looking for a possibility to (re)use one SQL select result to get the values ​​of diff...
From 2024-04-02 20:05:02
0
1
271
Limit SQL query conditions based on a column I have two tables, one is called user and the other is called payment. A user can have mul...
From 2024-04-02 17:17:29
0
1
306
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template