i tried to search, but couldn't find anything. but i'm using postgresql, but i want to group by every 6 hours. so something similar to date_trunc('hour', start_date) but every 6 hours. Continue reading...