Using SQL Server 2019 and Perspective 8.1.10.
I have a named query that gets a datetime field from SQL Server. The datetime appears correct in the dataset. When I bind the dataset from my named query to the table, it comes in as unix epoch time however. I have not changed anything about the table formatting. It looks like this
I have set “render” for this column to “date” and the “dateFormat” to 'MM/DD/YYYY` but I am seeing these unix dates in the table still. Any idea what I am doing wrong?