Kibana Discover calculating wrong date from timestamp


(Javier Alfonso) #1

Hello, i'm loading squid logs into elasticsearch using the java highlevelclient api.
I'm putting the timestamp as a date field, when i open kibana discover, all dates are placed in 1970, ej:

Blockquote

@timestamp:
January 18th 1970, 07:20:50.276

Blockquote

and in the JSON of that same item: "@timestamp": 1513250276.929, the conversion is jueves, 14 de diciembre de 2017 6:17:56.929, which is correct
Any sugestions?


(Felix Stürmer) #2

Hi @jalfonsocu,

Elasticsearch and Kibana expect timestamps to be in milliseconds. Your JSON example looks like it contains a float with milliseconds behind the decimal point. I would recommend to multiply these values with 1000 during ingestion in order to correct for that.


(Javier Alfonso) #3

thanks, problem solved


(system) #4

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