Date in UI Table

[marwinwijaya]

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

[zenofmud]

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

[marwinwijaya]

My output MySQL node on debug

[Christian-Me]

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

Ui-table date sort

Anyone know of a neat trick to get a ui-table to do sorting by date, rather than standard numeric sort? Thanks