<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv=Content-Type content="text/html; charset=iso-8859-2"><meta name=Generator content="Microsoft Word 14 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";
mso-fareast-language:EN-US;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.StylE-mailovZprvy17
{mso-style-type:personal-compose;
font-family:"Calibri","sans-serif";
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri","sans-serif";
mso-fareast-language:EN-US;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:70.85pt 70.85pt 70.85pt 70.85pt;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang=CS link=blue vlink=purple><div class=WordSection1><p class=MsoNormal>Hi guys,<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>we would like to change Timezone in the SOLR query by TZ parameter, but it doesnīt have any effect and we canīt take results.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Wiki:<o:p></o:p></p><p class=MsoNormal><a href="https://cwiki.apache.org/confluence/display/solr/Working+with+Dates">https://cwiki.apache.org/confluence/display/solr/Working+with+Dates</a><o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Part of the query:<o:p></o:p></p><p class=MsoNormal><i>… &fq=CurrentDate_cs_mdt:[2014-01-21T17:00:00Z TO 2014-01-22T17:00:00Z]&TZ=Europe/Prague …<o:p></o:p></i></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Datetime in the xmlcontent have this value:<o:p></o:p></p><p class=MsoNormal><i>2014-01-21T17:00:00Z<o:p></o:p></i></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>But i see datetimei n the SOLR index have this value:<o:p></o:p></p><p class=MsoNormal><i>2014-01-21T16:00:00Z<o:p></o:p></i></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>So in the real is here +1 hour time warp (depends on server settings???). I think itīs regular because dates in the SOLR are stored in the UTC. But for the regular results should be possible to use TZ parameter, but using it donīt have any effect.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>When we use query with -1HOUR correction, we take results:<o:p></o:p></p><p class=MsoNormal><i>… &fq=CurrentDate_cs_mdt:[2014-01-21T17:00:00Z-1HOUR TO 2014-01-22T17:00:00Z] …<o:p></o:p></i></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Or I'm wrong?<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Thank you very much for the help and hope to see you at OpenCms Days 2014.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><span style='color:#1F497D;mso-fareast-language:CS'>--<br>Regards<br>Filip Kratochvil<br>------------------------------------------------<br>NELASOFT Technologies, s.r.o.<br>E-mail: <a href="mailto:filip.kratochvil@nelasoft.cz"><span style='color:blue'>filip.kratochvil@nelasoft.cz</span></a><br>Web: <a href="http://www.nelasoft.cz" target="_blank"><span style='color:blue'>www.nelasoft.cz</span></a></span><span style='mso-fareast-language:CS'><o:p></o:p></span></p><p class=MsoNormal><o:p> </o:p></p></div></body></html>