# Timestamp conversion

**URL:** https://discuss.elastic.co/t/timestamp-conversion/242136
**Category:** Logstash
**Created:** [July 22, 2020, 5:47am UTC](https://discuss.elastic.co/t/timestamp-conversion/242136 "2020-07-22T05:47:28Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![ishank](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/ishank/32/72581_2.png) [@ishank](https://discuss.elastic.co/u/ishank)
#### Post date: [July 22, 2020, 5:47am UTC](https://discuss.elastic.co/t/timestamp-conversion/242136/1 "2020-07-22T05:47:28Z")

</div>

Hi

The data in my csv file is having the timestamp in format:

```auto
2019-04-11 12:00 AM

```

(There are 3 spaces between the date & time)

My logstash configuration for same:

```auto
filter{
date {
        match => ["Time", "yyyy-MM-dd hh:mm a"]
        target => "@timestamp"
      }
}

```

This works fine and I get the @timestamp in elasticsearch . But when I see the data in elasticsearch or kibana, I think it is picking up UTC time automatically.  
For example, the event happened at `2019-04-11 12:00 AM`, in Elasticsearch, it is shown as Apr 10, 2019 @ 18:30:00.000.

Please help.

---

<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: [July 22, 2020, 5:37pm UTC](https://discuss.elastic.co/t/timestamp-conversion/242136/2 "2020-07-22T17:37:57Z")

</div>

elasticsearch always stores date/time as UTC. By default kibana transforms those to the browser's timezone.

If your log files are not in UTC then use the timezone option of the date filter to tell it what timezone they are in.

---

<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: [August 19, 2020, 5:37pm UTC](https://discuss.elastic.co/t/timestamp-conversion/242136/3 "2020-08-19T17:37:59Z")

</div>

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