Timestamp field only shows as unix when Views aggregation is on and Timestamp field is Min or Max

Created on 18 August 2018, almost 6 years ago
Updated 24 January 2024, 5 months ago

Reproduce by creating a new view, enabling aggregation, adding a Watchdog Hostname group field, then add Timestamp field as Min or Max. The Timestamp will show as Unix number even though the setting is for Time Ago or default date time.

Now change the Timestamp field to Group (instead of Min or Max), then notice the formatting changes to Time ago or default date times, which is correct.

πŸ› Bug report
Status

Active

Version

9.5

Component
ViewsΒ  β†’

Last updated less than a minute ago

Created by

πŸ‡ΊπŸ‡ΈUnited States sajosh

Live updates comments and jobs are added and updated live.
Sign in to follow issues

Comments & Activities

Not all content is available!

It's likely this issue predates Contrib.social: some issue and comment data are missing.

  • πŸ‡¨πŸ‡¦Canada mdolnik

    Not necessarily a solution, but a workaround can be to use twig to render the resulting unix timestamp value as a date format.

    Configure Field > Rewrite Results > Override the output of this field with custom text

    Set the Text to:
    {{ created|date("Y-m-d H:i:s") }}

    Replace created with whatever the field name is in views and use whichever PHP date format you wish.

    Also you need to ensure Thousands marker is - None -

Production build 0.69.0 2024