# @timestamp format while exporting from elasticsearch to csv

**URL:** <https://discuss.elastic.co/t/timestamp-format-while-exporting-from-elasticsearch-to-csv/263137>\
**Category:** Logstash\
**Created:** [February 3, 2021, 2:55pm UTC](https://discuss.elastic.co/t/timestamp-format-while-exporting-from-elasticsearch-to-csv/263137 "2021-02-03T14:55:05Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![ritusingh](https://avatars.discourse-cdn.com/v4/letter/r/ac91a4/32.png) [@ritusingh](https://discuss.elastic.co/u/ritusingh)\
**Post date:** [February 3, 2021, 2:55pm UTC](https://discuss.elastic.co/t/timestamp-format-while-exporting-from-elasticsearch-to-csv/263137/1 "2021-02-03T14:55:06Z")

</div>

Hi,  
I want to know how can I change the format of @timestamp while exporting from elasticsearch to csv via logstash. In Kibana I have kept the format as "Feb-03-2021 20:03:04.603" using advance settings. I want same format in csv as well. I have kept following filter in logstash which is unfortunately not working.

```auto
filter {
      date {
        match => ["@timestamp", "MMM-dd-yyyy HH:mm:ss.SSS"]
      }
    }

```

Currently I am getting date as "2021-02-03T12:30:00.315Z" in 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:** [February 3, 2021, 4:38pm UTC](https://discuss.elastic.co/t/timestamp-format-while-exporting-from-elasticsearch-to-csv/263137/2 "2021-02-03T16:38:02Z")

</div>

If you want to reformat a Logstash::Timestamp then use a ruby filter and strftime.

---

<div class="post-metadata">

**Author:** ![ritusingh](https://avatars.discourse-cdn.com/v4/letter/r/ac91a4/32.png) [@ritusingh](https://discuss.elastic.co/u/ritusingh)\
**Post date:** [February 4, 2021, 2:35pm UTC](https://discuss.elastic.co/t/timestamp-format-while-exporting-from-elasticsearch-to-csv/263137/3 "2021-02-04T14:35:45Z")

</div>

Hi Badger,

```auto
ruby {
	code => "event.set('@timestamp' , event.get('@timestamp').time.strftime('%b-%d-%Y %H:%M:%S.%L'))"
	}

```

I tried this and got rubyexception. Can you please tell me the correct way?

---

<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 4, 2021, 5:00pm UTC](https://discuss.elastic.co/t/timestamp-format-while-exporting-from-elasticsearch-to-csv/263137/4 "2021-02-04T17:00:01Z")

</div>

There is an example [here](https://discuss.elastic.co/t/date-field-being-converted-to-timestamps/180044/4).

---

<div class="post-metadata">

**Author:** ![ritusingh](https://avatars.discourse-cdn.com/v4/letter/r/ac91a4/32.png) [@ritusingh](https://discuss.elastic.co/u/ritusingh)\
**Post date:** [February 5, 2021, 6:33am UTC](https://discuss.elastic.co/t/timestamp-format-while-exporting-from-elasticsearch-to-csv/263137/5 "2021-02-05T06:33:09Z")

</div>

Hi Badger,  
I tried that, will it change the original @timestamp format? Or I have to add some new field??  
Here is what I have tried:

```auto
ruby {
        code => '
            t = Time.at(event.get("@timestamp").to_f)
            event.set("@timestamp", t.strftime("%Y-%m-%d"))
        '
    }

```

I am still getting rubyexception.

---

<div class="post-metadata">

**Author:** ![ritusingh](https://avatars.discourse-cdn.com/v4/letter/r/ac91a4/32.png) [@ritusingh](https://discuss.elastic.co/u/ritusingh)\
**Post date:** [February 5, 2021, 10:15am UTC](https://discuss.elastic.co/t/timestamp-format-while-exporting-from-elasticsearch-to-csv/263137/6 "2021-02-05T10:15:12Z")

</div>

its resolved 🙂  
Thanks Badger

---

<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 5, 2021, 10:15am UTC](https://discuss.elastic.co/t/timestamp-format-while-exporting-from-elasticsearch-to-csv/263137/7 "2021-03-05T10:15:39Z")

</div>

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