Graylog2 / Graylog2/graylog2-server

Show user's timezone in `latest(timestamp)` in DataTable

Open
#15,339 2 comments 0 reactions 0 assignees View on GitHub
feature
Dominant language
Java
Stars
8.1k
Forks
1.1k
Avg merge
1d 20h
Merged PRs (30d)
217

Description

> It seems like this issue from the community could be related as well. Agregations in the search screen are ignoring timezone. https://community.graylog.org/t/aggregation-timestamp-reverts-to-utc-although-timestamp-field-is-utc-1/28237

Not 100% sure this is the same issue or not (so possibly we may need a separate issue? Will have to defer to dev/eng. on this one). For clarity though:

# What

When using aggregations (e.g. metrics via Graylog) on the timestamp field, the timezone offset of the user is ignored and timestamps are only displayed in their raw original UTC format.

![image](https://user-images.githubusercontent.com/107503402/227966252-ef2a516c-0a3c-48b9-b0c8-08aeec34a901.png)

# Expected behavior
Anywhere a timestamp is, its display using the user's declared timezone offset preference. For this specific example, the aggregated timestamps have the user's offset applied.

# Current behavior
Timestamp is displayed as UTC

# Your Environment
* Graylog Version: 5.0.5
* Java Version: Bundled
* ~~Elasticsearch~~ OpenSearch Version: OpenSearch 2.6
* MongoDB Version: 6.0.4
* Operating System: Ubuntu Server 22.04 LTS
* Browser version: Chrome 111.0.5563.110

_Originally posted by @drewmiranda-gl in https://github.com/Graylog2/graylog2-server/issues/15030#issuecomment-1485191642_

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.