GuyC
Senior Member
Joined: 11 Aug 2009 Posts: 1281 Location: Belgium
|
|
|
|
Code: |
select
date(My_timestamp)
,time('00.00.00') + (midnight_seconds(My_timestamp) / 900 * 900) seconds
,time('00.00.00') + (midnight_seconds(My_timestamp) / 900 * 900 + 899) seconds
, count(*)
from My_table
group by
date(My_timestamp)
,time('00.00.00') + (midnight_seconds(My_timestamp) / 900 * 900) seconds
,time('00.00.00') + (midnight_seconds(My_timestamp) / 900 * 900 + 899) seconds
|
|
|