3 ms·Can you paste code on how #2 was done?by jlu 4y agoCan you paste code on how #2 was done?joneholland 4y agoTime stamp % 24jlu 4y agothat's clever, thanks!eis 4y agoThat does not get you hourly time slots. You either want something like floor(timestamp / 3600) or timestamp - timestamp % 3600