# Timezone adjustments in query

**URL:** <https://discuss.elastic.co/t/timezone-adjustments-in-query/168587>\
**Category:** Elasticsearch\
**Created:** [February 15, 2019, 12:38pm UTC](https://discuss.elastic.co/t/timezone-adjustments-in-query/168587 "2019-02-15T12:38:15Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Darshan\_Parab](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/darshan_parab/32/51098_2.png) [@Darshan\_Parab](https://discuss.elastic.co/u/Darshan_Parab)\
**Post date:** [February 15, 2019, 12:38pm UTC](https://discuss.elastic.co/t/timezone-adjustments-in-query/168587/1 "2019-02-15T12:38:15Z")

</div>

I wrote a query to fetch data from and index and aggregate it using date\_histogram aggregation. I'm working in IST (GMT+5.30) Timezone. I applied a filter to get events occurred today using "now/d" expression. Apparantly, this results in 0000 Hrs in GMT. As a result, I'm getting incomplete results. Looking out for the way so that "now/d" returns 0000 Hrs in IST Timezone.

When I Visualize the data using Kibana, it picks up IST timezone and gives correct results. Only when I query elasticsearch using dev tools or python, I notice the said behavior.

Find below the query and corresponding results.

> {  
> "size": 0,  
> "query": {  
> "bool": {  
> "filter": {  
> "range": {  
> "timestamp": {  
> "gte": "now/d"  
> }  
> }  
> }  
> }  
> },  
> "aggs": {  
> "timestamp": {  
> "date\_histogram": {  
> "field": "timestamp",  
> "interval": "hour"  
> }  
> }  
> }  
> }

> {  
> "took" : 86,  
> "timed\_out" : false,  
> "\_shards" : {  
> "total" : 5,  
> "successful" : 5,  
> "skipped" : 0,  
> "failed" : 0  
> },  
> "hits" : {  
> "total" : 1332097,  
> "max\_score" : 0.0,  
> "hits" :   
> },  
> "aggregations" : {  
> "timestamp" : {  
> "buckets" : [  
> {  
> "key\_as\_string" : "2019-02-15T00:00:00.000Z",  
> "key" : 1550188800000,  
> "doc\_count" : 16063  
> },  
> {  
> "key\_as\_string" : "2019-02-15T01:00:00.000Z",  
> "key" : 1550192400000,  
> "doc\_count" : 16818  
> },  
> {  
> "key\_as\_string" : "2019-02-15T02:00:00.000Z",  
> "key" : 1550196000000,  
> "doc\_count" : 19957  
> },  
> {  
> "key\_as\_string" : "2019-02-15T03:00:00.000Z",  
> "key" : 1550199600000,  
> "doc\_count" : 34773  
> },  
> {  
> "key\_as\_string" : "2019-02-15T04:00:00.000Z",  
> "key" : 1550203200000,  
> "doc\_count" : 80339  
> },  
> {  
> "key\_as\_string" : "2019-02-15T05:00:00.000Z",  
> "key" : 1550206800000,  
> "doc\_count" : 130403  
> },  
> {  
> "key\_as\_string" : "2019-02-15T06:00:00.000Z",  
> "key" : 1550210400000,  
> "doc\_count" : 165722  
> },  
> {  
> "key\_as\_string" : "2019-02-15T07:00:00.000Z",  
> "key" : 1550214000000,  
> "doc\_count" : 154612  
> },  
> {  
> "key\_as\_string" : "2019-02-15T08:00:00.000Z",  
> "key" : 1550217600000,  
> "doc\_count" : 143965  
> },  
> {  
> "key\_as\_string" : "2019-02-15T09:00:00.000Z",  
> "key" : 1550221200000,  
> "doc\_count" : 158271  
> },  
> {  
> "key\_as\_string" : "2019-02-15T10:00:00.000Z",  
> "key" : 1550224800000,  
> "doc\_count" : 176818  
> },  
> {  
> "key\_as\_string" : "2019-02-15T11:00:00.000Z",  
> "key" : 1550228400000,  
> "doc\_count" : 132230  
> },  
> {  
> "key\_as\_string" : "2019-02-15T12:00:00.000Z",  
> "key" : 1550232000000,  
> "doc\_count" : 102126  
> }  
> ]  
> }  
> }  
> }

Query with timezone adjustment and corresponding results.

> {  
> "size": 0,  
> "query": {  
> "bool": {  
> "filter": {  
> "range": {  
> "timestamp": {  
> "gte": "now/d-330m"  
> }  
> }  
> }  
> }  
> },  
> "aggs": {  
> "timestamp": {  
> "date\_histogram": {  
> "field": "timestamp",  
> "interval": "hour"  
> }  
> }  
> }  
> }

> {  
> "took" : 276,  
> "timed\_out" : false,  
> "\_shards" : {  
> "total" : 5,  
> "successful" : 5,  
> "skipped" : 0,  
> "failed" : 0  
> },  
> "hits" : {  
> "total" : 1426095,  
> "max\_score" : 0.0,  
> "hits" :   
> },  
> "aggregations" : {  
> "timestamp" : {  
> "buckets" : [  
> {  
> "key\_as\_string" : "2019-02-14T18:00:00.000Z",  
> "key" : 1550167200000,  
> "doc\_count" : 11035  
> },  
> {  
> "key\_as\_string" : "2019-02-14T19:00:00.000Z",  
> "key" : 1550170800000,  
> "doc\_count" : 20879  
> },  
> {  
> "key\_as\_string" : "2019-02-14T20:00:00.000Z",  
> "key" : 1550174400000,  
> "doc\_count" : 17171  
> },  
> {  
> "key\_as\_string" : "2019-02-14T21:00:00.000Z",  
> "key" : 1550178000000,  
> "doc\_count" : 16916  
> },  
> {  
> "key\_as\_string" : "2019-02-14T22:00:00.000Z",  
> "key" : 1550181600000,  
> "doc\_count" : 13300  
> },  
> {  
> "key\_as\_string" : "2019-02-14T23:00:00.000Z",  
> "key" : 1550185200000,  
> "doc\_count" : 14697  
> },  
> {  
> "key\_as\_string" : "2019-02-15T00:00:00.000Z",  
> "key" : 1550188800000,  
> "doc\_count" : 16063  
> },  
> {  
> "key\_as\_string" : "2019-02-15T01:00:00.000Z",  
> "key" : 1550192400000,  
> "doc\_count" : 16818  
> },  
> {  
> "key\_as\_string" : "2019-02-15T02:00:00.000Z",  
> "key" : 1550196000000,  
> "doc\_count" : 19957  
> },  
> {  
> "key\_as\_string" : "2019-02-15T03:00:00.000Z",  
> "key" : 1550199600000,  
> "doc\_count" : 34773  
> },  
> {  
> "key\_as\_string" : "2019-02-15T04:00:00.000Z",  
> "key" : 1550203200000,  
> "doc\_count" : 80339  
> },  
> {  
> "key\_as\_string" : "2019-02-15T05:00:00.000Z",  
> "key" : 1550206800000,  
> "doc\_count" : 130403  
> },  
> {  
> "key\_as\_string" : "2019-02-15T06:00:00.000Z",  
> "key" : 1550210400000,  
> "doc\_count" : 165722  
> },  
> {  
> "key\_as\_string" : "2019-02-15T07:00:00.000Z",  
> "key" : 1550214000000,  
> "doc\_count" : 154612  
> },  
> {  
> "key\_as\_string" : "2019-02-15T08:00:00.000Z",  
> "key" : 1550217600000,  
> "doc\_count" : 143965  
> },  
> {  
> "key\_as\_string" : "2019-02-15T09:00:00.000Z",  
> "key" : 1550221200000,  
> "doc\_count" : 158271  
> },  
> {  
> "key\_as\_string" : "2019-02-15T10:00:00.000Z",  
> "key" : 1550224800000,  
> "doc\_count" : 176818  
> },  
> {  
> "key\_as\_string" : "2019-02-15T11:00:00.000Z",  
> "key" : 1550228400000,  
> "doc\_count" : 132230  
> },  
> {  
> "key\_as\_string" : "2019-02-15T12:00:00.000Z",  
> "key" : 1550232000000,  
> "doc\_count" : 102126  
> }  
> ]  
> }  
> }  
> }

Suggestions if anyone have faced similar issues.  
Thanks

---

<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 15, 2019, 12:38pm UTC](https://discuss.elastic.co/t/timezone-adjustments-in-query/168587/2 "2019-03-15T12:38:19Z")

</div>

Closed on March 15, 2019, 12:38pm UTC

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