Skip to Main Content

Group and count rows in 5 minute intervals

To group time-series data into days, hours, or minutes you round the dates to the desired unit. But what if you want to count the rows in groups of five, ten, or fifteen minutes?

To do this you need to calculate which time period a datetime falls in. Join this session to learn how to do this calculation and learn how 23.7 simplifies this with a built-in function: TIME_BUCKET.

Resources

Featured Speakers

  • Speaker

    Chris Saxon


    Oracle Developer Advocate for SQL

Workshop Info

Session Has Completed - 18 February 2025
1 Hour
English
SQL

Other Upcoming Sessions