You have two options for dates in this scenario, "tdate" or "dateRange". Probably in this case use dateRange, it should be more time and space efficient. Here's some background:
https://lucidworks.com/blog/2016/02/13/solrs-daterangefield-perform/ Date types should be indexed as fully specified strings, as YYYY-MM-DDThh:mm:ssZ Best, Erick On Mon, Apr 11, 2016 at 3:03 PM, Steven White <swhite4...@gmail.com> wrote: > Hi everyone, > > I need to index data data into Solr and then use this field for facet > search. My question is this, the date data in my DB is stored in the > following format "2016-03-29 15:54:35.461": > > 1) What format I should be indexing this date + time stamp into Solr? > 2) What Solr field type I should be using? Is it "date"? > 3) How do I handle various time zones and locales? > 4) Can I insert multi value data data into the single "date" facet field > and still use this field for facet search? > 5) Based on my need, will all the Date Math per [1] on date facet still > work? I'm confused here because of my need for (3). > > To elaborate on (4) some more. The need here is this. In my DB, there are > more than one column with date data. I will be indexing them all into this > single multi-value Solr field of type Date that I will then use for facet. > Is this possible? > > I guess, this is a two part question, for date facet: a) how to properly > index, and b) how do I properly search. > > As always, any insight is greatly appreciated. > > Steve > > [1] https://cwiki.apache.org/confluence/display/solr/Working+with+Dates