OK. Feels a bit strange that one would have to do this manual calculation in every place that performs searches like this. Would be much more logical if solr supported specifying the timezone in the query (with a default setting being possible to configure in solrconfig), and that solr itself did this conversion behind the scenes. Maybe that will come in the future?
/Jimi > -----Ursprungligt meddelande----- > Från: Michael Ryan [mailto:mr...@moreover.com] > Skickat: den 21 maj 2014 16:23 > Till: solr-user@lucene.apache.org > Ämne: RE: Date truncation and time zone when searching > > Well for CEST, which is 2 hours ahead, I would think you could just do... > > datefield:[* TO NOW/MONTH-2HOURS] > > That would give you everything up to 2014-04-30 22:00:00 GMT, which is > 2014-05-01 00:00:00 CEST. > > Always always always store the correct value. > > -Michael > > -----Original Message----- > From: jimi.hulleg...@svensktnaringsliv.se > [mailto:jimi.hulleg...@svensktnaringsliv.se] > Sent: Wednesday, May 21, 2014 10:12 AM > To: solr-user@lucene.apache.org > Subject: Date truncation and time zone when searching > > Hi, > > What is the prefered way to do searches with date truncation with respect to > a specific time zone? The dates are stored correctly, ie I can see the UTC > date > in the index and if I add 1 or 2 hours (depending on daylight saving time or > not) I get the time in our time zone (CET/CEST). But when I search I want to > be able to do something like: > > datefield:[* TO NOW/MONTH] > or: > datefield:[* TO NOW/DAY+3DAYS] > etc... > > ...and I want the MONTH or DAY truncation to correspond to our time zone. > How can I achieve this? Some of our dates are have the time set to 00:00 > (CET/CEST), but since the date truncation logic in solr only handles UTC that > would classify those documents to "belong to the day before", and if the > date is on 00:00 on January 1, then the document is even considered to > belong to the year before it's actual year! > > Surely I can't be the only one hindered by this. What are the common > workarounds used today? Some people mention that they trick solr by using > the date and time expressed as for their own time zone, and then claiming > that the time zone is UTC. Ie saying "2000-01-01T00:00:00Z" for the beginning > of this millennium, even though it should be "1999-12-31T23:00:00Z". But I > don't like this idea of storing incorrect date values in the index, since > then we > need to "convert" them again before we display them. > > Regards > /Jimi
