# Datetime from sql to Timestamp logstash

**URL:** <https://discuss.elastic.co/t/datetime-from-sql-to-timestamp-logstash/117594>\
**Category:** Logstash\
**Created:** [January 30, 2018, 9:58am UTC](https://discuss.elastic.co/t/datetime-from-sql-to-timestamp-logstash/117594 "2018-01-30T09:58:41Z")\
**Posts on this page:** 1\
**Showing post:** 18

<div class="post-metadata">

**Author:** ![ericohtake](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/ericohtake/32/24539_2.png) [@ericohtake](https://discuss.elastic.co/u/ericohtake)\
**Post date:** [February 1, 2018, 10:22am UTC](https://discuss.elastic.co/t/datetime-from-sql-to-timestamp-logstash/117594/18 "2018-02-01T10:22:02Z")

</div>

Anuar, always post examples of your data as you did now. Much easier to try to help. 😀

Your datetime field is in the format, " **ISO8601**".  
Try this:

```
filter {
  date {
     match => ["datetime", "ISO8601"]
     timezone => "Etc/UTC"
    }
}

```

[https://www.elastic.co/guide/en/logstash/current/plugins-filters-date.html#plugins-filters-date-match](https://www.elastic.co/guide/en/logstash/current/plugins-filters-date.html#plugins-filters-date-match)

---

_[View the full topic](https://discuss.elastic.co/t/datetime-from-sql-to-timestamp-logstash/117594)._