# Convert a column in csv to hour time

**URL:** <https://discuss.elastic.co/t/convert-a-column-in-csv-to-hour-time/163098>\
**Category:** Logstash\
**Created:** [January 6, 2019, 10:47pm UTC](https://discuss.elastic.co/t/convert-a-column-in-csv-to-hour-time/163098 "2019-01-06T22:47:07Z")\
**Posts on this page:** 1\
**Showing post:** 2

<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:** [January 7, 2019, 9:38pm UTC](https://discuss.elastic.co/t/convert-a-column-in-csv-to-hour-time/163098/2 "2019-01-07T21:38:17Z")

</div>

```
ruby { code => 'event.set("HOUR", LogStash::Timestamp.new(event.get("DAY")+ 3600 * event.get("HOUR")))' }

```

Error handling is left as an exercise for the reader.

---

_[View the full topic](https://discuss.elastic.co/t/convert-a-column-in-csv-to-hour-time/163098)._