Perfect, now I have a row for each second from midnight to approximately 5.5 hours later. What if my duration need to vary because I’m going to compute these ranges for a number of different scenarios? I should make that 19565 into a variable and let’s overengineer this by making it a bigint.
Things don’t work out quite the way you might have expected there. Read on and see what Bill found and how you can circumvent the problem.