Hi Chris, Thanks for replying.
but if your goal, as you said, is to index 0000-00-00T00:00:00Z for > documenst that have no value in the date field -- i have to ask why? I was just trying to index the fields returned by my msql and i found this issue. So i asked in the group. Sorry for writing a confusing mail. Actually i just want to know why it is getting stored as ' 0002-11-30T00:00:00Z' on indexing the value 0000-00-00T00:00:00Z. Is it somewhere pre-defined? With Regards Aman Tandon On Thu, Oct 30, 2014 at 11:17 PM, Chris Hostetter <hossman_luc...@fucit.org> wrote: > > Solr has never really owrked well with years prior to "1" because the > specs for how they should be formated/parsed -- in particular realted to > "year 0" have always been painfully ambiguious/contradictory. > > https://issues.apache.org/jira/browse/SOLR-2773 > > If you are really trying to deal with "year 0" and dates that are "BC" > then the current TrieDateField code probably isn't going to work well for > you -- but if your goal, as you said, is to index 0000-00-00T00:00:00Z for > documenst that have no value in the date field -- i have to ask why? > > the best solution is to not index anything in that field for those > documents -- that will should give you the optimal behavior in all > situations (queries, faceting, returned documents, etc...) > > so why do you want to put 0000-00-00T00:00:00Z in these documents? > > https://people.apache.org/~hossman/#xyproblem > XY Problem > > Your question appears to be an "XY Problem" ... that is: you are dealing > with "X", you are assuming "Y" will help you, and you are asking about "Y" > without giving more details about the "X" so that we can understand the > full issue. Perhaps the best solution doesn't involve "Y" at all? > See Also: http://www.perlmonks.org/index.pl?node_id=542341 > > > > > : Date: Thu, 30 Oct 2014 14:09:13 +0530 > : From: Aman Tandon <amantandon...@gmail.com> > : Reply-To: solr-user@lucene.apache.org > : To: "solr-user@lucene.apache.org" <solr-user@lucene.apache.org> > : Subject: issue related to blank value in datefield > : > : Hi, > : > : I wants to set 0000-00-00T00:00:00Z value for date field where I do not > : have the value. When the index the at field with value as desired it is > : getting indexed as 0002-11-30T00:00:00Z. > : > : What is the reason behind this? > : > : With Regards > : Aman Tandon > : > > -Hoss > http://www.lucidworks.com/ >