My Question is:
When the result of a Named Query is a Dataset and the first Column contains the Start Date in UnixFormat (Integer Seconds since 1.1.1970).
How can i convert all values in the first column to show the actual Date DD.MM.YYYY ss:mm:hh?
If you use the columns property of the perspective table you can specify some formatting rules.
Simply enter the column name in field (exactly matching how it is in the data) set the render mode as date and then select the desired dateFormat.
This is the result I get when using millisecond time, if it does not work for you try converting from seconds to millis.
NOTE:
If you need to alter the format beyond the preset options you can customize it further to do something like DD-MM-YYYY by manually typing it into the dateFormat property
2 Likes