# Timestamp does not take the time zone

**URL:** <https://discuss.elastic.co/t/timestamp-does-not-take-the-time-zone/252082>\
**Category:** Elasticsearch\
**Tags:** elastic-stack-monitoring, elastic-stack-alerting\
**Created:** [October 14, 2020, 5:18pm UTC](https://discuss.elastic.co/t/timestamp-does-not-take-the-time-zone/252082 "2020-10-14T17:18:27Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![victor.vera](https://avatars.discourse-cdn.com/v4/letter/v/898d66/32.png) [@victor.vera](https://discuss.elastic.co/u/victor.vera)\
**Post date:** [October 14, 2020, 5:18pm UTC](https://discuss.elastic.co/t/timestamp-does-not-take-the-time-zone/252082/1 "2020-10-14T17:18:28Z")

</div>

**I have a problem with the time stamp, I have the correct date, but the time is wrong, I have like 5 hours in advance, the date is correct but I do not know why I have another time of execution, I put the time zone but it does not serve me continues to leave the time forward , I need to have the time zone UTC-5 America/Bogota.**

**this is the code**

```auto
{
  "trigger": {
    "schedule": {
      "interval": "1h"
    }
  },
  "input": {
    "search": {
      "request": {
        "search_type": "query_then_fetch",
        "indices": [
          "agenteallot*"
        ],
        "rest_total_hits_as_int": true,
        "body": {
          "size": 0,
          "query": {
            "bool": {
              "filter": {
                "range": {
                  "@timestamp": {
                    "gte": "{{ctx.trigger.scheduled_time}}||-5m",
                    "lte": "{{ctx.trigger.scheduled_time}}",
                    "formats": [
                      "dd/MM/yyyy HH:mm:ss"
                    ],
                    "timezone": "UTC-5"
                  }
                }
              }
            }
          },
          "aggs": {
            "bucketAgg": {
              "query": {
                "bool": {
                  "filter": {
                    "term": {
                      "monitor.name.keyword": "01-1-CAV30328203-DATOS-PPAL-2.7G-99.98"
                    }
                  }
                }
              },
              "aggs": {
                "metricAgg": {
                  "max": {
                    "field": "summary.up"
                  }
                }
              }
            }
          }
        }
      }
    }
  },
  "condition": {
    "script": {
      "source": "ArrayList arr = ctx.payload.aggregations.bucketAgg.buckets; for (int i = 0; i < arr.length; i++) { if (arr[i]['metricAgg'].value >= params.threshold) { return true; } } return false;",
      "lang": "painless",
      "params": {
        "threshold": 0.8
      }
    }
  },
  "actions": {
    "email_1": {
      "email": {
        "profile": "standard",
        "attach_data": {
          "format": "yaml"
        },
        "to": [
          "juan.jaramillo@megadvantage.com",
          "victor.vera@megadvantage.com"
        ],
        "subject": "{{ctx.metadata.name}} {{ctx.payload.results}}",
        "body": {
          "text": """Buen dia, Adjunto registro del reporte.

 ⚠️ALERTA NODO!!! El siguiente enlace perdió la conexión. 

 Estado: Down🔴 

 Nombre del Enlace: {{ctx.payload.results}} 

 🕧Hora: {{ctx.execution_time}} {{ctx.result.execution_time}}

 Área: Networking 

 🔔Mensaje Alerta: El enlace ha dejado de responder. Responder correo a telecomunicaciones@udistrital.edu.co 

 Ingrese aquí para más información: https://72dfe17217744236af40cc31b704a664.us-central1.gcp.cloud.es.io:9243/s/distrital/app/uptime#"""
        }
      }
    }
  },
  "transform": {
    "script": {
      "source": "HashMap result = new HashMap(); ArrayList arr = ctx.payload.aggregations.bucketAgg.buckets; ArrayList filteredHits = new ArrayList(); for (int i = 0; i < arr.length; i++) { HashMap filteredHit = new HashMap(); filteredHit.key = arr[i].key; filteredHit.value = arr[i]['metricAgg'].value; if (filteredHit.value >= params.threshold) { filteredHits.add(filteredHit); } } result.results = filteredHits; return result;",
      "lang": "painless",
      "params": {
        "threshold": 0.8
      }
    }
  }
}

```

**this is the error...**

 ![5 horas adelantado](https://us1.discourse-cdn.com/elastic/original/3X/9/1/91494fac6ae6b73b941e626b348e0a127a805ca8.png)

---

<div class="post-metadata">

**Author:** ![spinscale](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/spinscale/32/25011_2.png) [@spinscale](https://discuss.elastic.co/u/spinscale)\
**Post date:** [October 16, 2020, 1:49pm UTC](https://discuss.elastic.co/t/timestamp-does-not-take-the-time-zone/252082/2 "2020-10-16T13:49:16Z")

</div>

please do not post screenshots, as they are impossible to read for many. Just use snippets and paste the text in there.

I assume, that the time is correct it is just displayed as UTC, but that does not make it wrong. Can you explain why this time is wrong? When did the watch actually execute?

---

<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:** [November 13, 2020, 1:49pm UTC](https://discuss.elastic.co/t/timestamp-does-not-take-the-time-zone/252082/3 "2020-11-13T13:49:26Z")

</div>

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