# Time format 30.12.2019 14:06:00 GMT+00:00

**URL:** <https://discuss.elastic.co/t/time-format-30-12-2019-1400-gmt-00-00/229256>\
**Category:** Logstash\
**Created:** [April 22, 2020, 12:30pm UTC](https://discuss.elastic.co/t/time-format-30-12-2019-1400-gmt-00-00/229256 "2020-04-22T12:30:40Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Yaniv\_Nuriel](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/yaniv_nuriel/32/66359_2.png) [@Yaniv\_Nuriel](https://discuss.elastic.co/u/Yaniv_Nuriel)\
**Post date:** [April 22, 2020, 12:30pm UTC](https://discuss.elastic.co/t/time-format-30-12-2019-1400-gmt-00-00/229256/1 "2020-04-22T12:30:40Z")

</div>

Dear all,

Any idea how to match the following date format?

```auto
30.12.2019 14:06:00 GMT+00:100 

```

This is not working

```auto
dd.MM.yyy HH:mm:ss zzz

```

---

<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:** [April 22, 2020, 3:32pm UTC](https://discuss.elastic.co/t/time-format-30-12-2019-1400-gmt-00-00/229256/2 "2020-04-22T15:32:51Z")

</div>

> [@Yaniv\_Nuriel](#):
>
> 30.12.2019 14:06:00 GMT+00:100

Can you explain what that format means?

---

<div class="post-metadata">

**Author:** ![Yaniv\_Nuriel](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/yaniv_nuriel/32/66359_2.png) [@Yaniv\_Nuriel](https://discuss.elastic.co/u/Yaniv_Nuriel)\
**Post date:** [April 22, 2020, 4:03pm UTC](https://discuss.elastic.co/t/time-format-30-12-2019-1400-gmt-00-00/229256/3 "2020-04-22T16:03:12Z")

</div>

Sure, sorry about that. I am getting _\_dateparsefailure_

I have the following config file:

```auto
input {
        file {
            path => "/Users/yanivnuriel/logstash/data/tests/gmt/test.csv"
            start_position => "beginning"
            sincedb_path => "NUL"
        }
}
filter{

    csv {
        separator => ","
        autodetect_column_names => true
        autogenerate_column_names => true

    	columns => ["date/time"]
    	
    }

    date {
        match => ["date/time", "dd.MM.yyy HH:mm:ss"]
        timezone => "GMT"
        target => "@timestamp"
    }
}

output {
    stdout { }
}

```

With the following source:

```auto
"date/time"
24.03.2020 01:59:38 GMT+00:00

```

and the output is:

```auto
{
    "@timestamp" => 2020-04-22T16:01:36.040Z,
       "message" => "24.03.2020 01:59:38 GMT+00:00",
     "date/time" => "24.03.2020 01:59:38 GMT+00:00",
          "tags" => [
        [0] "_dateparsefailure"
    ],
          "host" => "Yanivs-MBP",
      "@version" => "1",
          "path" => "/Users/yanivnuriel/logstash/data/tests/gmt/test.csv"
}

```

---

<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:** [April 22, 2020, 4:42pm UTC](https://discuss.elastic.co/t/time-format-30-12-2019-1400-gmt-00-00/229256/4 "2020-04-22T16:42:36Z")

</div>

> [@Yaniv\_Nuriel](#):
>
> "message" =\> "24.03.2020 01:59:38 GMT+00:00"

I would try

```
date { match => ["message", "dd.MM.YYYY HH:mm:ss 'GMT'ZZ"] }

```

---

<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:** [May 20, 2020, 4:42pm UTC](https://discuss.elastic.co/t/time-format-30-12-2019-1400-gmt-00-00/229256/5 "2020-05-20T16:42:43Z")

</div>

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