Re: queries including time zone

2013-11-18 Thread Chris Hostetter
: We're still not seeing the proper result. I've included a gist of the : query and its debug result. This was run on a clean index running 4.4.0 : with just one document. That document has a date of 11/15/2013 yet the : date in the included TZ it is the 14th but I still get that document :

Re: queries including time zone

2013-11-18 Thread Eric Katherman
Anybody have any additional suggestions for this TZ issue we're having? I've included the query below. The full debug output is in the gist link also included if you want to see it. As mentioned, the test solr installation has one document with a date that was set to the 15th, and when this q

Re: queries including time zone

2013-11-14 Thread Eric Katherman
We're still not seeing the proper result.I've included a gist of the query and its debug result. This was run on a clean index running 4.4.0 with just one document. That document has a date of 11/15/2013 yet the date in the included TZ it is the 14th but I still get that document returned.

Re: queries including time zone

2013-11-14 Thread Chris Hostetter
I've beefed up the ref guide page on dates to include more info about all of this... https://cwiki.apache.org/confluence/display/solr/Working+with+Dates -Hoss

Re: queries including time zone

2013-11-14 Thread Chris Hostetter
: Can anybody provide any insight about using the tz param? The behavior : of this isn't affecting date math and /day rounding. What format does : the tz variables need to be in? Not finding any documentation on this. it's not "tz" it's "TZ" The input/output format is always in UTC, but TZ w

Re: queries including time zone

2013-11-14 Thread Erick Erickson
IMO you will save yourself endless grief just biting the bullet and working with UTC at all times. The instant you have uses in even adjacent but different time zones, you'll have to deal with this anyway. FWIW, Erick On Thu, Nov 14, 2013 at 12:26 AM, Jack Krupansky wrote: > I believe it is the

Re: queries including time zone

2013-11-13 Thread Jack Krupansky
I believe it is the TZ column from this table: http://en.wikipedia.org/wiki/List_of_tz_database_time_zones Yeah, it's on my TODO list for my book. I suspect that "tz" will not affect "NOW", which is probably UTC. I suspect that "tz" only affects literal dates in date math. -- Jack Krupansky