Commits

Carey Tilden committed a365911

Switched to round instead of ceil, so interval groups are more of a mid point than an upper limit

Comments (0)

Files changed (1)

share/SuperHostile08-deaths.sql

         order by 1
     ),
     play_time_groups as (
-        select play_time, :interval_group_secs * ceil(extract('epoch' from play_time)/:interval_group_secs) / 60
+        select play_time, :interval_group_secs * round(extract('epoch' from play_time)/:interval_group_secs) / 60
             as interval_group
         from play_times order by play_time
     )