Is it possible to cast or convert Unixtime column to datetime in the view?
You should be able to create a Calculated Field in the View that converts your Unix time data to a DateTime format using a function like MySQL's
The syntax for MySQL can be found here, however, it would depend on the DBMS you are using.
It also for mssql?
I found this Stack Overflow article that would be helpful.
I believe the equivalent would be:
dateadd(S, [unixtime], '1970-01-01')
Where you would not need the 'Select' and 'From table' parts of the statement.
I'm just checking in to see how you are going with your question. If you have any further questions, please don't hesitate to reach out, otherwise, I will go ahead and mark this ticket as completed.
I'm just messaging to let you know that I am marking this question as answered.
Comments have been locked on this page!