Fork me on GitHub
#xtdb
<
2019-09-27
>
jumar08:09:27

Does crux always store datetimes as UTC or is there an option to use different timezones as well?

malcolmsparks11:09:04

They're stored as java.util.Date so UTC - in your app you would have to store the timezome in the document (or in fixed configuration) and use java.time.ZonedDateTime to convert the date to local time.

👍 4
hoppy22:09:16

ok, as the adventure continues....what is the "proper" way in crux to leverage indexes that are based on inequalities. Think 100 timecards/day, over 10 years, and I want to pull out those from 1Q-2001.

hoppy22:09:18

crux answers this question correctly, but it "feels" like it is going through all the entities and applying the predicates rather than leveraging the index that would strike most of them