I have stock market bid/offer data. I’ve read that dimensions can only be 64 ints. So my question is about how to best convert time to 64 ints. The finance examples I have seen on github use ms past the start of the day. Since the examples are only for one day, the issue of year-month-day is elided. On the forum, I’ve seen the recommendation that the y-m-d be converted to the number of days from some well known start date. My question is whether SciDB has a preferred conversion that it uses with its own temporal data types so that any conversion to a SciDB data type in the future would be easier. Dates can be tricky with the edge cases.
Also, would breaking year-month-day into 3 dimensions be efficient for manipulating stock data in SciDB?