Can I convert epoch time via data views to be readable?

good day,

my app log is in epoch time format (sample: 1700529701700), can I convert this using script in data views to be human readable format in discover menu? or any suggestion how to convert this?

i saw this in google, but I encountered "Cannot cast from [java.util.Date] to [void]. Verify that you have correctly set the runtime field type." error

return new Date(Long.parseLong(doc["TXN_END.keyword"].value));

thank you very much

or idea on how to put this epoch time format in mappings / template?

Hi @geeboy1 welcome to the community!

Did you look at

There are examples on that page

hi @stephenb thank you :slight_smile:

is below template correct?

data views:

PUT _index_template/app1audit-template
  "index_patterns": ["app1audit*"],
  "template": {
    "settings": {
      "number_of_shards": 1,
      "number_of_replicas": 0,
      "": "180-days-default",      
      "index.lifecycle.rollover_alias": "app1audit-alias"    
    "mappings": {
         "_source": {
            "enabled": true
	    "properties" : {
        "TXN_START" : {
        "format" : "yyyy-MM-dd HH:mm:ss,SSS",  <--- is this correct? or what format should I put here?
        "type" : "date"

Perhaps this one

A formatter for the number of milliseconds since the epoch. Note, that this timestamp is subject to the limits of a Java Long.MIN_VALUE and Long.MAX_VALUE.


format" : "epoch_millis",

Or as it says right in the beginning of the docs I referred you to.

Date formats can be customised, but if no format is specified then it uses the default:


So you could also just not specify a format or use that one....

thanks a lot for the explanation @stephenb :slight_smile: this one works!!

Which this one :wink:

Always good for others to show your solution...

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