Bucketizing date and time data
SQL Performance
AUGUST 11, 2021
For example, the measurements could be temperature and humidity readings taken every 5 minutes, and you want to group the data using hourly buckets and compute aggregates like average per hour. For example, you might want to organize sales data in fiscal year buckets and compute aggregates like the total sales value per fiscal year.
Let's personalize your content