# Logstash converting date / Time in correctly

**URL:** <https://discuss.elastic.co/t/logstash-converting-date-time-in-correctly/210266>\
**Category:** Logstash\
**Created:** [December 3, 2019, 2:12am UTC](https://discuss.elastic.co/t/logstash-converting-date-time-in-correctly/210266 "2019-12-03T02:12:54Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Trevorp](https://avatars.discourse-cdn.com/v4/letter/t/5fc32e/32.png) [@Trevorp](https://discuss.elastic.co/u/Trevorp)\
**Post date:** [December 3, 2019, 2:12am UTC](https://discuss.elastic.co/t/logstash-converting-date-time-in-correctly/210266/1 "2019-12-03T02:12:54Z")

</div>

When I am importing data to logstash it does not handle the data/Time correctly

It shows time Dec 2, 2019 @ 21:09:29.000

when it should show 2019/12/03 05:09:29

Message in Kibana

tmessage 2019/12/03 05:09:29,95,MP Member Policies,200,OK,View Current Policy 7-1,true,5556,1,23,[https://Statements=true-GetSisDetails=true-PolicyType=](https://Statements=true-GetSisDetails=true-PolicyType=),94,SERVERNAME,0,14

Raw Data

2019/12/03 05:09:29,95,MP Member Policies,200,OK,View Current Policy 7-1,true,5556,1,23,[https://Statements=true-GetSisDetails=true-PolicyType=](https://Statements=true-GetSisDetails=true-PolicyType=),94,SERVERNAME,0,14

filter {  
csv {  
columns =\> ["time","elapsed","label","responseCode","responseMessage","threadName","success","bytes","grpThreads","allThreads","url","latency","Hostname","IdleTime","Connect"]  
}

#Logstash date config section

date {  
match =\> ["time","yyyy/MM/dd HH:mm:ss"]  
target =\> "time"  
}

Can any one help with this?

---

<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:** [December 3, 2019, 1:05pm UTC](https://discuss.elastic.co/t/logstash-converting-date-time-in-correctly/210266/2 "2019-12-03T13:05:46Z")

</div>

logstash and elasticsearch store times in the UTC timezone. kibana will, by default, convert them to the browsers local timezone. If your logs are not in your local timezone you can use the timezone option on 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:** [December 31, 2019, 1:10pm UTC](https://discuss.elastic.co/t/logstash-converting-date-time-in-correctly/210266/3 "2019-12-31T13:10:26Z")

</div>

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