I'm reading data from a Microsoft SQL Server (MSSQL) database table. One column, named TSCreated , stores timestamps in milliseconds (standard UNIX Epoch time) as a BigInt data type, not a datetime.
When I display the data using a named query in a Perspective table, I can set the render type for the TSCreated column to "date" and it displays the datetime in the correct format. However, if I display the same named query in a report, TSCreated is shown as a number, not a datetime (see attached screenshot).
How can I instruct the reporting module to display the TSCreated column as a date?
If you can't/won't change the query to do the casting to a true date time type (this is the best place to do it) you'll need to use a script data source to rewrite the column using a system.date function to parse the millis into a Java Date object.
You could use a script like this to do the column update:
