# Problem with timezone conversion - full timestamp vs time only field

**URL:** <https://discuss.elastic.co/t/problem-with-timezone-conversion-full-timestamp-vs-time-only-field/141979>\
**Category:** Elasticsearch\
**Created:** [July 27, 2018, 6:09pm UTC](https://discuss.elastic.co/t/problem-with-timezone-conversion-full-timestamp-vs-time-only-field/141979 "2018-07-27T18:09:19Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![cvraocv](https://avatars.discourse-cdn.com/v4/letter/c/3e96dc/32.png) [@cvraocv](https://discuss.elastic.co/u/cvraocv)\
**Post date:** [July 27, 2018, 6:09pm UTC](https://discuss.elastic.co/t/problem-with-timezone-conversion-full-timestamp-vs-time-only-field/141979/1 "2018-07-27T18:09:19Z")

</div>

All,

I am facing a problem with inconsitent timezone conversion in visualization - between a full timestamp field and a time only field. Looked around and didn't find a solution. Please help!

I have loaded 2 different date fields into Elastic like below in UTC. Using the console, I am able to see the same - correctly. FYI, actual time is just the time portion of end date. Loaded this data using logstash

**"enddate": "2018-07-19 12:10:45",**  
**"actualtime": "12:10:45",**

My browser / system is in Pacific time zone. With Day light savings on, we expect it to subtract 7 hours from the UTC data loaded above.

In Discover, I was able to see enddate correctly as 5:10: 45 in PDT, but looks like actual time is getting subtracted with 8 hours and not 7 - which is the case with PST and not PDT - showing 4:10:45

**enddate:July 19th 2018, 05:10:45.000 actualtime: 04:10:45**

Both the fields are defined as Date fields in the mapping and I am using the pattern as "HH:mm:ss" for actual time

Let me know if there is anything I am missing here and thanks in advance for your help!

FYI - I asked this in Kibana forums and I got a suggestion to ask about this in ES forum.

Regards,  
Venkat

---

<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 24, 2018, 6:09pm UTC](https://discuss.elastic.co/t/problem-with-timezone-conversion-full-timestamp-vs-time-only-field/141979/2 "2018-08-24T18:09:21Z")

</div>

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