Aggregation for a timewindow

[Priyanka shekhawat]

I am new to mysql. Can somebody please help me by converting this ORACLE query to mysql?

There are two columns in a table (experiment). The dttm column is date data type and qty column is integer. I want to sum up the qty value for the interval of first 10 minutes and next 10 minutes etc etc.

select trunc(dttm,'hh24') +
(trunc(to_char(dttm,'mi')/10)*10)/24/60, sum(qty)
from experiment
group by trunc(dttm,'hh24') + (trunc(to_char(dttm,'mi')/10)*10)/24/60
order by trunc(dttm,'hh24') + (trunc(to_char(dttm,'mi')/10)*10)/24/60;

What would be the equivalent SQL in mysql?

thank and Best Regards,
Priyanka