datetime in Elasticsearch - How to handle timezone
<p>I try to index a field containing a date.</p>

<p>How can I index a date from a different timezone ?</p>

<p>I've set my elasticsearch field like so :
'requested_dt': {"type": "date", "format": "date_time_no_millis"}
'local_dt': {"type": "date", "format": "date_time_no_millis"}</p>

<p>I've tried to index these values (local_dt) :
(requested_dt is the current time in France)</p>

<pre><code>IT 2016-10-27T23:46:17Z
GB 2016-10-27T22:46:19Z
</code></pre>

<p>I don't get the expected result through Kibana : </p>

<pre><code>[local_dt]
IT October 28th 2016, 01:46:17.000
GB October 28th 2016, 00:46:19.000

[requested_dt]
IT October 27th 2016, 23:46:17.000
GB October 27th 2016, 23:46:19.000
</code></pre>

<p>So, for requested_dt, I get what I expect.</p>

<p>For local_dt, I don't get what I want.</p>

<p>I've tried to replace the Z value with the UTC offset but I'm not able to get the correct output.</p>

<p>Is there someone able to explain to me how to get the correct output for each timezone I want ? </p>