# Coverting miliseconds into HH:mm:ss in logstash

**URL:** <https://discuss.elastic.co/t/coverting-miliseconds-into-hhss-in-logstash/263098>\
**Category:** Logstash\
**Created:** [February 3, 2021, 8:47am UTC](https://discuss.elastic.co/t/coverting-miliseconds-into-hhss-in-logstash/263098 "2021-02-03T08:47:05Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![mohanss08](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/mohanss08/32/82297_2.png) [@mohanss08](https://discuss.elastic.co/u/mohanss08)\
**Post date:** [February 3, 2021, 8:47am UTC](https://discuss.elastic.co/t/coverting-miliseconds-into-hhss-in-logstash/263098/1 "2021-02-03T08:47:05Z")

</div>

The below is my csv output data inserted to elasticsearch through logstash.

```auto
"build_end_time" => "2021-01-13 01:29:49",
"build_duration" => "6409651",
"build_start_time" => "2021-01-12 23:43:00",
"build_date" => "2021-01-12",
"@timestamp" => 2021-02-02T11:40:50.747Z,

```

Currently `"build_duration" => "6409651",` i have in milliseconds format. before inserting into elasticsearch is it possible to convert into `HH:mm:ss:ss` format in my logstash.conf file itself? if yes please help me to achieve this? i tried with below way but unable to succeeded.

```
filter {
  csv {
      separator => ","
      columns => ["build_date", "start_time", "build_start_time", "build_end_time", "build_duration", "requester", "full-name", "metric_id", "config", "status"]
       }
  ruby {
  code => "event.set('build_duration', event.get('build_duration').to_f / 1000 * 60))"
      }
}
```

---

<div class="post-metadata">

**Author:** ![mohanss08](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/mohanss08/32/82297_2.png) [@mohanss08](https://discuss.elastic.co/u/mohanss08)\
**Post date:** [February 24, 2021, 5:34pm UTC](https://discuss.elastic.co/t/coverting-miliseconds-into-hhss-in-logstash/263098/2 "2021-02-24T17:34:36Z")

</div>

Any help will be highly appreciated.

---

<div class="post-metadata">

**Author:** ![Badger](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/badger/32/25190_2.png) [@Badger](https://discuss.elastic.co/u/Badger)\
**Post date:** [February 24, 2021, 5:58pm UTC](https://discuss.elastic.co/t/coverting-miliseconds-into-hhss-in-logstash/263098/3 "2021-02-24T17:58:03Z")

</div>

You could do that with a scripted field in kibana (see [here](https://discuss.elastic.co/t/json-input-converting-minutes-to-minutes-and-seconds/100845) and [here](https://discuss.elastic.co/t/convert-number-into-time-hhss/235494/4) for examples).

In logstash you could do it using a ruby filter. See [here](https://stackoverflow.com/questions/40485828/convert-milliseconds-to-hours-and-mins-in-ruby/40486133) and [here](https://stackoverflow.com/questions/14686649/how-can-i-convert-milliseconds-in-string-format-to-hhmmss-format-in-ruby-in-un) for code examples.

---

<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:** [March 24, 2021, 5:58pm UTC](https://discuss.elastic.co/t/coverting-miliseconds-into-hhss-in-logstash/263098/4 "2021-03-24T17:58:39Z")

</div>

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