Graylog2 / Graylog2/graylog2-server
Show user's timezone in `latest(timestamp)` in DataTable
- 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.

# 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
Assessment
This issue has not been assessed yet.