Hi
Got it thanks to debug option
TZ applies only to date computations, so you have to compute a date :)
The document {"date" : "2016-12-31T04:15:00Z", "desc" : "winter time day
before" }
is retrieved with query date:[2016-12-31T12:15:00Z/DAY TO
2017-01-03T12:15:00Z/DAY] and "TZ":"Europe/Paris" that translates to
[2016-12-30T23 TO 2017-01-02T23:00:00]
the same query with TZ=America/New_York translates to [2016-12-31T05 TO
2017-01-03T05:00:00] and does not retrives the doc
Cheers
On 20/07/2017 02:10, Ulul wrote:
> Hi everyone
>
> I'm trying to query on dates with time zone taken into account. I have
> the following document
>
> {"date" : "2016-12-31T04:15:00Z", "desc" : "winter time day before" }
> date being of type DateRangeField
>
> I would like to be able to perform a query based on local date. For
> instance the above date corresponds to 2016-12-30 in New York (UTC-5 in
> winter) so I would expect the following query NOT to retrieve the document :
>
> http://127.0.1.1:7574/solr/date_test/select?TZ=America/New_York&indent=on&q=date:2016-12-31&wt=json
>
> Unfortunately it does... and it's the same using filter query
>
> https://cwiki.apache.org/confluence/display/solr/Working+with+Dates
> describes how to use TZ in facets, why doesn't it work with simple queries ?
>
> I'm using Solr 6.5.1
>
> I had to add DateRangeField type myself to the collection schema. I did
> it with :
>
> curl -X POST -H 'Content-type:application/json' --data-binary '{
> "add-field-type" : {
> "name":"DateRangeField",
> "class":"solr.DateRangeField"
> }
> }' http://localhost:7574/solr/date_test/schema
>
> Thank you for your help
>
> Ulul
>
