convert unixtime format to datetime
Answered
Hi all,
Is it possible to cast or convert Unixtime column to datetime in the view?
Thanks
Hi all,
Is it possible to cast or convert Unixtime column to datetime in the view?
Thanks
Hi Amir,
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.
Kind regards,
Simon
It also for mssql?
Hi Amir,
I found this Stack Overflow article that would be helpful.
I believe the equivalent would be:
Where you would not need the 'Select' and 'From table' parts of the statement.
Kind regards,
Simon
Hi Amir,
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.
Kind regards,
Simon
Hi Amir,
I'm just messaging to let you know that I am marking this question as answered.
Kind regards,
Simon
Comments have been locked on this page!