计算两个时间戳之间数据库中的行数

Question

In my database I'm using the current time stamp based on the customer orders, stored in a table. I want to know, within two time periods, how many customers order a request. Suppose 10:12:16 to 13:32:54, in this time period how many(count) customers requested? In the same way as in between 2 dates.

Answer 1

SELECT * FROM your_table WHERE time_stamp_column BETWEEN '10:12:16' AND '13:32:54';