# Kibana Discover calculating wrong date from timestamp

**URL:** https://discuss.elastic.co/t/kibana-discover-calculating-wrong-date-from-timestamp/114289
**Category:** Kibana
**Created:** [January 5, 2018, 1:56pm UTC](https://discuss.elastic.co/t/kibana-discover-calculating-wrong-date-from-timestamp/114289 "2018-01-05T13:56:32Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![jalfonsocu](https://avatars.discourse-cdn.com/v4/letter/j/e9a140/32.png) [@jalfonsocu](https://discuss.elastic.co/u/jalfonsocu)
#### Post date: [January 5, 2018, 1:56pm UTC](https://discuss.elastic.co/t/kibana-discover-calculating-wrong-date-from-timestamp/114289/1 "2018-01-05T13:56:32Z")

</div>

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?

---

<div class="post-metadata">

### Author: ![weltenwort](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/weltenwort/32/53885_2.png) [@weltenwort](https://discuss.elastic.co/u/weltenwort)
#### Post date: [January 8, 2018, 11:46am UTC](https://discuss.elastic.co/t/kibana-discover-calculating-wrong-date-from-timestamp/114289/2 "2018-01-08T11:46:46Z")

</div>

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.

---

<div class="post-metadata">

### Author: ![jalfonsocu](https://avatars.discourse-cdn.com/v4/letter/j/e9a140/32.png) [@jalfonsocu](https://discuss.elastic.co/u/jalfonsocu)
#### Post date: [January 8, 2018, 4:20pm UTC](https://discuss.elastic.co/t/kibana-discover-calculating-wrong-date-from-timestamp/114289/3 "2018-01-08T16:20:13Z")

</div>

thanks, problem solved

---

<div class="post-metadata">

### Author: ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)
#### Post date: [February 5, 2018, 4:20pm UTC](https://discuss.elastic.co/t/kibana-discover-calculating-wrong-date-from-timestamp/114289/4 "2018-02-05T16:20:16Z")

</div>

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