Aggregate on hour

Migrateduser

<p>I need to aggregate data that is collected every 30 seconds by hour. There is a datetime field in the row but I need to know how to strip the hour field out</p>