Kibana shows different date from original document-CodePudding

I have folloving issue

Elastic mapping:

...  
"logtime" : {
          "type":"date",
          "format":"YYYY-MM-dd HH:mm:ss,SSS"     
        }
...

Elastic document:

PUT nifi_test_test/_doc/1
{
  "logtime" :"2022-01-12 14:42:07,786"
}

Kibana output :

{
  "_index": "nifi_test_test",
  "_type": "_doc",
  "_id": "1",
  "_version": 1,
  "_score": 1,
  "_source": {
    "logtime": "2022-01-12 14:42:07,786"
  },
  "fields": {
    "logtime": [
      "2022-01-03T14:42:07.786Z"
    ]
  }
}

Elastic output from query:

...     
 {
        "_index" : "nifi_test_test",
        "_type" : "_doc",
        "_id" : "1",
        "_score" : 1.0,
        "_source" : {
          "logtime" : "2022-01-12 14:42:07,786"
        }
      }
...

Kibana Index patternIndex pattern for date field

Kibana Discover: Discover date

I wonder why in elastic I see correct date - the same as document, but in Kibana day in date always = 3 ?

Thank you in advance

CodePudding user response：

Set the format:

{"format": "yyyy-MM-dd HH:mm:ss,SSS"}

YYYY is a week based year

See DateTimeFormatter docs also help you!