Current location - Quotes Website - Signature design - An SQL, which takes data from 8: 00-9: 00, 9:00- 10:00 and displays it in the form of columns.
An SQL, which takes data from 8: 00-9: 00, 9:00- 10:00 and displays it in the form of columns.
If the time type is 2015-5-2615: 57: 31,the query statement can be like, and the signature is underlined.

Select * from table where time like' _ _ _ _ _ _ _ 09:' or time like' _ _ _ _ _ 09:' or time like' _ _ _ _ _ _10:'

If what is stored in the repository is (15:57:3 1)

select * from table where time ' 8:00 ' between ' 9:00 '