Skip to content

ui-table cannot display locale date/time #1772

Description

@Steve-Mcl

Current Behavior

Background

Using a table to display tabular data with timestamps is common practice.
To render time in users local format, the processing must be done client side (or the server side needs awareness of the clients timezone & locale)
When a timestamp (js/unix epoch) is sent to the table, there is no post processing possible (and no automatic detection and parsing)

Current Behaviour

  • Sending a column with js/unix epoch - renders a long number
  • Sending a column with Date object - renders UTC time

Expected Behavior

one or more of the following:

  • Set Columns
    • Column setup should have a datetime field setup with various formats and potentially moment style custom format
  • Auto Columns
    • Option to parse "date-like" numbers into locale datetime
    • Optional cell formatters (e.g. [{ col: "date": "dd-MMM-yyyy", {col: "time": "HH:mm"}])

Steps To Reproduce

No response

Environment

  • Dashboard version: 1.25.0
  • Node-RED version:
  • Node.js version:
  • npm version:
  • Platform/OS:
  • Browser:

Have you provided an initial effort estimate for this issue?

I have provided an initial effort estimate

Metadata

Metadata

Assignees

Labels

size:XSHigh-level sizingtype:bugSomething isn't working

Type

No type

Projects

Status
Review
Status
Backlog

Milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions