How to set configure timestamp in Map

Elastic Stack Kibana
1

Hi,

In Map, I have chosen absolute date range, 17 Jul 2020@00:00:00:00 till 23 Jul 2020@00:00:00:00. However, under the Inspect/Request I found the code "gte": "2020-07-16T16:00:00.000Z",
"lte": "2020-07-22T16:00:00.000Z", as follows:

"query": {
"bool": {
"must": ,
"filter": [
{
"match_all": {}
},
{
"range": {
"timestamp": {
"gte": "2020-07-16T16:00:00.000Z",
"lte": "2020-07-22T16:00:00.000Z",
"format": "strict_date_optional_time"
}
}
}
],
"should": ,
"must_not":
}
}
}

I have tired set timezone under Management/Advanced Settings-> Timezone for date formatting to my timezone.

Anyone, please suggest me on how to setup the timestamp in Map ?

map_date_select map_request

2

Hi @GraceYu! What time zone are you in or are you setting in advanced settings?

I ask because the time in the query is 8 hours off from the time range in the UI so I imagine that the UI is doing the conversion and sending all the queries in UTC.

3

Hi Michail,

I have set time zone to MYT Malaysia time zone. Is there a way to set to my local time zone ?

Thanks,
Grace

4

Here's how it works;

  1. Your browser uses the timezone of the OS
  2. Kibana converts that into UTC, taking into account offsets
  3. Kibana talks to Elasticsearch in UTC
  4. All timestamps in Elasticsearch are in UTC

You shouldn't need to worry about changing the timestamp in Kibana at all.

5

Hi Mark Walkom,

Thanks for the explanation. If this is the case, are you recommending that data to be stored in UTC ?

Thanks,
Grace

6

The data will always be stored in Elasticsearch in UTC, you cannot change that.

7

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.