# Logstash: convert date string to timestamp in millisecond

**URL:** <https://discuss.elastic.co/t/logstash-convert-date-string-to-timestamp-in-millisecond/52845>\
**Category:** Logstash\
**Created:** [June 15, 2016, 9:42am UTC](https://discuss.elastic.co/t/logstash-convert-date-string-to-timestamp-in-millisecond/52845 "2016-06-15T09:42:14Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![sen](https://avatars.discourse-cdn.com/v4/letter/s/cc9497/32.png) [@sen](https://discuss.elastic.co/u/sen)\
**Post date:** [June 15, 2016, 9:42am UTC](https://discuss.elastic.co/t/logstash-convert-date-string-to-timestamp-in-millisecond/52845/1 "2016-06-15T09:42:14Z")

</div>

Hello everyone,

I have a filed date where my date is in the following format: 2016-03-30T12:37:27.424709000Z and I would like to convert it in millisecond.

Do you how to do ? I didn't find a solution

Thank you for your help and your attention.

S

---

<div class="post-metadata">

**Author:** ![magnusbaeck](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/magnusbaeck/32/44943_2.png) [@magnusbaeck](https://discuss.elastic.co/u/magnusbaeck)\
**Post date:** [June 15, 2016, 9:47am UTC](https://discuss.elastic.co/t/logstash-convert-date-string-to-timestamp-in-millisecond/52845/2 "2016-06-15T09:47:16Z")

</div>

Perhaps you can use the mutate filter's gsub option to replace the last six digits with an empty string, i.e. `\d{6}Z$` -\> `Z`.

---

<div class="post-metadata">

**Author:** ![sen](https://avatars.discourse-cdn.com/v4/letter/s/cc9497/32.png) [@sen](https://discuss.elastic.co/u/sen)\
**Post date:** [June 15, 2016, 11:18am UTC](https://discuss.elastic.co/t/logstash-convert-date-string-to-timestamp-in-millisecond/52845/3 "2016-06-15T11:18:30Z")

</div>

Hi Magnus,

Thank you for the info but how i am supposed to use that in order to get the date in milliseconds.

---

<div class="post-metadata">

**Author:** ![magnusbaeck](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/magnusbaeck/32/44943_2.png) [@magnusbaeck](https://discuss.elastic.co/u/magnusbaeck)\
**Post date:** [June 15, 2016, 11:47am UTC](https://discuss.elastic.co/t/logstash-convert-date-string-to-timestamp-in-millisecond/52845/4 "2016-06-15T11:47:57Z")

</div>

Did you look at the documentation of the mutate filter's gsub option?

---

<div class="post-metadata">

**Author:** ![sen](https://avatars.discourse-cdn.com/v4/letter/s/cc9497/32.png) [@sen](https://discuss.elastic.co/u/sen)\
**Post date:** [June 15, 2016, 1:39pm UTC](https://discuss.elastic.co/t/logstash-convert-date-string-to-timestamp-in-millisecond/52845/5 "2016-06-15T13:39:49Z")

</div>

Yes, I did 🙂 !  
Actually, I finally found what i was looking for:  
ruby {  
code =\> "event['milli'] = 1000\*Time.parse(event['[myDate]']).to\_f"  
}

---

<div class="post-metadata">

**Author:** ![magnusbaeck](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/magnusbaeck/32/44943_2.png) [@magnusbaeck](https://discuss.elastic.co/u/magnusbaeck)\
**Post date:** [June 15, 2016, 4:54pm UTC](https://discuss.elastic.co/t/logstash-convert-date-string-to-timestamp-in-millisecond/52845/6 "2016-06-15T16:54:26Z")

</div>

_Oh_, you wanted to convert the timestamp to milliseconds since the epoch? Then I misunderstood your question.

---

<div class="post-metadata">

**Author:** ![sen](https://avatars.discourse-cdn.com/v4/letter/s/cc9497/32.png) [@sen](https://discuss.elastic.co/u/sen)\
**Post date:** [June 16, 2016, 7:50am UTC](https://discuss.elastic.co/t/logstash-convert-date-string-to-timestamp-in-millisecond/52845/7 "2016-06-16T07:50:40Z")

</div>

no problem 😉 !

---

<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:** [July 6, 2017, 4:52am UTC](https://discuss.elastic.co/t/logstash-convert-date-string-to-timestamp-in-millisecond/52845/8 "2017-07-06T04:52:31Z")

</div>