Hello, I am Arwin. I want to ask about UI Tables. I have data on Mysql in year-month-date format, but when the display format changes to something like the following image, how do I change it to a format like mine? Thank you very much [Prob 3]

Put a debug node on the output of the mysql node and show us what the data looks like. what is the format of the date column - in the mysql database - defined as?

[Screenshot_1] My output MySQL node on debug

Tabulator (the base of ui-table) has so called formatters for this. Perhaps this thread can help: [image] Ui-table date sort FAQs Anyone know of a neat trick to get a ui-table to do sorting by date, rather than standard numeric sort? Thanks

Node-RED

Node-RED Forum

Date in UI Table

Dashboard

Christian-Me 19 December 2020 15:39 4

Tabulator (the base of ui-table) has so called formatters for this. Perhaps this thread can help:

Topic		Replies	Views
Ui-table date sort FAQs	6	2607	29 February 2020
Ui_table filter by date Dashboard	10	1524	17 May 2021
How can i filter data table (ui_table) by date? General	7	2130	9 August 2020
[Solved] How to change timestamps in objects to date/time for ui_table FAQs	12	2825	28 June 2020
Simple ui_table to sort "desc" on load Dashboard	5	240	1 May 2024

Copyright OpenJS Foundation and Node-RED contributors. All rights reserved. The OpenJS Foundation has registered trademarks and uses trademarks. For a list of trademarks of the OpenJS Foundation, please see our Trademark Policy and Trademark List. Trademarks and logos not indicated on the list of OpenJS Foundation trademarks are trademarks™ or registered® trademarks of their respective holders. Use of them does not imply any affiliation with or endorsement by them.

Date in UI Table

Related topics