They can be indexed by hour, yet still be compared at more granular levels. Hour index helps us narrow down the search field, but then we use normal comparisons to check if the entries in the search field match the query parameters.
Related topics
| Topic | Replies | Views | Activity | |
|---|---|---|---|---|
| Date Comparisons - Speed differences with data at scale | 12 | 181 | May 21, 2025 | |
| Don't understand DateTime search index in GraphQL | 7 | 1231 | September 7, 2020 | |
| Very poor dateTime index/filtering performance when large numbers of nodes have the same date | 2 | 641 | July 5, 2021 | |
| What's the benefit to using a dateTime @index(hour) vs a string @index(exact) | 1 | 828 | December 6, 2018 | |
| How to search within a time range, rather than date range? | 4 | 1165 | December 14, 2018 |