Use Epoch Format with Nanoseconds (19 digits)

[andre_bx (Andre S.)]

Hi,

i am beginner with elastic, but i would use elastic for our Bluecat DNS Server.

The Server send the time as Unix epoche format with 19 digits, so i checked it and it is in nanoseconds like google search told me.

I search and test something but i don´t find the correct settings for type and format.

Is it possible to use the 19 digit epoch format with elastic?

Regardes Andre

[RabBit_BR (andre.coelho)]

Hi @andre_bx

Try use the epoch formats:

PUT idx_test
{
  "mappings": {
    "properties": {
      "time": {
        "type": "date",
        "format": "epoch_millis"
      }
    }
  }
}

POST idx_test/_doc/1
{
  "time":"1710335200000000000"
}

[andre_bx (Andre S.)]

@RabBit_BR thx for your response and idea!

I can insert the timestamp but it has wrong format if i take a look in the document (picture below).

Regardes