I picked date using datetime input component and saved in database:
now when I am retrieving it using following query to perspective table its showing wrong value:
SELECT expense.expenseId,
expense.employeeName,
expense.description,
expense.job,
expense.cdnTotal,
expense.usdTotal,
expense.euroTotal,
expense.expenseDate,
expense.selected
FROM expense
You’ll need to configure the props.columns section of your table. The props.columns[x].field should be equals to the column name, set your props.columns[x].dateFormat as you like and if needed, force the props.columns[x].render to date.
The props.columns can be auto generated by your dataset with the system.dataset.getColumnHeaders. If you want to have some flexibility on your table, the columns attribute is the way to go.