# Let kibana convert certain lines from epoch to human understandable

**URL:** https://discuss.elastic.co/t/let-kibana-convert-certain-lines-from-epoch-to-human-understandable/206144
**Category:** Kibana
**Created:** [November 1, 2019, 10:25am UTC](https://discuss.elastic.co/t/let-kibana-convert-certain-lines-from-epoch-to-human-understandable/206144 "2019-11-01T10:25:40Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![tmans1991](https://avatars.discourse-cdn.com/v4/letter/t/71e660/32.png) [@tmans1991](https://discuss.elastic.co/u/tmans1991)
#### Post date: [November 1, 2019, 10:25am UTC](https://discuss.elastic.co/t/let-kibana-convert-certain-lines-from-epoch-to-human-understandable/206144/1 "2019-11-01T10:25:41Z")

</div>

hello,

very new to kibana, need some help with the folowing:

there are certain files that i have imported, and some lines in these files  
contain epoch, and therefore not understandable

example  
rec\_time: 1572603306.438582  
ref\_time: 1572602602.4252398  
ts: 1572603306.447535  
and many more lines that contain epoch

can i tell to kibana:  
'hey if you see _these_ lines, convert them to DD-MM-YYYY for me?'  
if so: can you tell me where i can add the lines so that kibana converts them?

thanks!

---

<div class="post-metadata">

### Author: ![Nathan\_Reese](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/nathan_reese/32/84829_2.png) [@Nathan\_Reese](https://discuss.elastic.co/u/Nathan_Reese)
#### Post date: [November 1, 2019, 2:07pm UTC](https://discuss.elastic.co/t/let-kibana-convert-certain-lines-from-epoch-to-human-understandable/206144/2 "2019-11-01T14:07:07Z")

</div>

What is the mapping for `rec_time `, `ref_time `, and `ts` fields? Are they mapped as [date fields](https://www.elastic.co/guide/en/elasticsearch/reference/current/date.html)? To find this information, go to management =\> index patterns =\> and click your index pattern. Look at the row for each field and view the type. If the mapping is `number` then you will need to re-index the data so the values are mapped as `dates`.

You can set up [field formatters](https://www.elastic.co/guide/en/kibana/current/managing-fields.html) on each field to configure how the value should be formatted.

---

<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: [November 29, 2019, 2:07pm UTC](https://discuss.elastic.co/t/let-kibana-convert-certain-lines-from-epoch-to-human-understandable/206144/3 "2019-11-29T14:07:07Z")

</div>

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