Timestamp different in table vs json formats of a document on kibana

Here is a screenshot of a table format of a document

image

And here is the json format

{
  "_index": "myindex-0-2015.06.14",
  "_type": "_doc",
  "_id": "5rJ5-WMB0hr6ZbxCBDYn",
  "_version": 1,
  "_score": null,
  "_source": {
    "http_req_header_contentlength": "84",
    "unix_time": 1434318679000,
    "type": "syslog",
    "browser_build": "",
    "browser_device": "Other",
    "tags": [
      "dataset0"
    ],
    "@version": "1",
    "browser_name": "Firefox",
    "@timestamp": "2015-06-14T21:51:19.000Z",
"fields": {
    "unix_time": [
      "2015-06-14T21:51:19.000Z"
    ],
    "@timestamp": [
      "2015-06-14T21:51:19.000Z"
    ]
  },
  "sort": [
    1434318679000
  ]

How is this even possible?

Timezones. You're storing the dates as UTC via the ISO-8601 format and Kibana translates this to the timezone specified in your Kibana advanced settings (your current time-zone by default).

1 Like

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