3 ms·
> In this example, we could use a range scan instead of the YEAR function to obtain the same result. The range scan will miss all items with a created_at from
by berkle4455 3y ago
> In this example, we could use a range scan instead of the YEAR function to obtain the same result.
The range scan will miss all items with a created_at from 2023-12-31 00:00:01 to 2023-12-31 23:59:59
- aarondf 3y agoThat's true, I forgot to add the time. I'll update! Thanks
- slt2021 3y agofrom 2023-12-31 00:00:00.000 to 2023-12-31 23:59:59.999
- berkle4455 3y agowouldn't '2023-12-31' cast to '2023-12-31 00:00:00.000'? And it's the +1 ms where the cutoff begins?