Convert crtime column - epoch to ISO human-readable time

[dmwpepper]

I have a csv time containing a unix crtime column with values like 1528926082 that I want to convert while importing the .csv file. The above would convert to “Wed Jun 13 2018 21:41:22 GMT+0000”.

I’ve tried adding it in as a Text and Keyword type and then modifying the script with
{
“startTime”: {
“format”: “epoch_millis”,
“type”: “date”
}

but it produces a JSON error. Thanks for help!

[Manu_Agarwal]

Hi Dave,

In your json script closing braces is missing. Although you can simply do it by selecting the date field type and using this format under the advance mappings:

{
“format”: “epoch_millis”
}

Thanks
Manu