# Change time zone in the based on my search request

**URL:** <https://discuss.elastic.co/t/change-time-zone-in-the-based-on-my-search-request/88803>\
**Category:** Elasticsearch\
**Created:** [June 9, 2017, 8:09am UTC](https://discuss.elastic.co/t/change-time-zone-in-the-based-on-my-search-request/88803 "2017-06-09T08:09:10Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Ravi\_Shanker\_Reddy](https://avatars.discourse-cdn.com/v4/letter/r/a5b964/32.png) [@Ravi\_Shanker\_Reddy](https://discuss.elastic.co/u/Ravi_Shanker_Reddy)\
**Post date:** [June 9, 2017, 8:09am UTC](https://discuss.elastic.co/t/change-time-zone-in-the-based-on-my-search-request/88803/1 "2017-06-09T08:09:10Z")

</div>

I have a field "time" which is saving as UTC into the Database. How Can i search the document with the timezone I need???

Ex:  
//Saving in UTC into Database  
{  
"\_index": "alertsfromsocketio",  
"\_type": "logs",  
"\_id": "AVyLyEC5O5j6WhAHI4qn",  
"\_score": 1,  
"\_source": {  
"CUSTOMER": "TeleDNA",  
"GROUP\_NAME": "Testing",  
"IP\_ADDRESS": "172.16.23.14",  
"LOCATION": "GEMS LAB",  
"NODE\_NAME": "Development",  
"STATUS": "CPU USAGE IS 2",  
"VENDOR\_NAME": "TeleDNA",  
"DETAIL1": "cpu",  
"METRIC": "system.cpu.idle",  
"PRODUCT\_NAME": "smsc",  
"VALUE": "2",  
"ALARM\_NAME": "CPU",  
"level": "OK",  
"TYPE": "monitor",  
"time": "2017-06-09 07:36:13",  
"gems": "Correctable"  
}  
}  
//How Can I retrive it with +05.30 time zone  
{  
"\_index": "alertsfromsocketio",  
"\_type": "logs",  
"\_id": "AVyLyEC5O5j6WhAHI4qn",  
"\_score": 1,  
"\_source": {  
"CUSTOMER": "TeleDNA",  
"GROUP\_NAME": "Testing",  
"IP\_ADDRESS": "172.16.23.14",  
"LOCATION": "GEMS LAB",  
"NODE\_NAME": "Development",  
"STATUS": "CPU USAGE IS 2",  
"VENDOR\_NAME": "TeleDNA",  
"DETAIL1": "cpu",  
"METRIC": "system.cpu.idle",  
"PRODUCT\_NAME": "smsc",  
"VALUE": "2",  
"ALARM\_NAME": "CPU",  
"level": "OK",  
"TYPE": "monitor",  
"time": "2017-06-09 14:06:13",  
"gems": "Correctable"  
}  
}

How to Query to get this type of result???

---

<div class="post-metadata">

**Author:** ![Ravi\_Shanker\_Reddy](https://avatars.discourse-cdn.com/v4/letter/r/a5b964/32.png) [@Ravi\_Shanker\_Reddy](https://discuss.elastic.co/u/Ravi_Shanker_Reddy)\
**Post date:** [June 19, 2017, 9:59am UTC](https://discuss.elastic.co/t/change-time-zone-in-the-based-on-my-search-request/88803/2 "2017-06-19T09:59:14Z")

</div>

Anyone can help me on this????

---

<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:** [July 17, 2017, 9:59am UTC](https://discuss.elastic.co/t/change-time-zone-in-the-based-on-my-search-request/88803/3 "2017-07-17T09:59:28Z")

</div>

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