sql - Trying to Get 15 Minute Intervals from MySQL Database -


i have sql string trying count in 15 minute intervals previous day. not show rows after 12pm. ideas?

select count(*),        minute(`que_timestamp`) div 15 `peorid`,        hour(`que_timestamp`) `hour` `que` date (`que_timestamp`) = (curdate() - 1) group hour(`que_timestamp`),          minute(`que_timestamp`) div 15 order `hour` asc 

my que_timestamp mysql timestamp enter image description here


Comments

Popular posts from this blog

Capture and play voice with Asterisk ARI -

java - Why database contraints in HSQLDB are only checked during a commit when using transactions in Hibernate? -

visual studio - Installing Packages through Nuget - "Central Directory corrupt" -