convert unixtime format to datetime

Amir shared this question ago

Answered

Hi all,

Is it possible to cast or convert Unixtime column to datetime in the view?

Thanks

The same question

Comments (5)

Simon Karumbi ● 9 months ago

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

FROM_UNIXTIME()

The syntax for MySQL can be found here, however, it would depend on the DBMS you are using.

Kind regards,

Simon

Reply URL

Amir ● 9 months ago

It also for mssql?

Reply URL

Simon Karumbi ● 9 months ago

Hi Amir,

I found this Stack Overflow article that would be helpful.

I believe the equivalent would be:

Select
    dateadd(S, [unixtime], '1970-01-01')
From [Table]

Where you would not need the 'Select' and 'From table' parts of the statement.

Kind regards,

Simon

Reply URL

Simon Karumbi ● 8 months ago

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

Reply URL

Simon Karumbi ● 8 months ago

Hi Amir,

I'm just messaging to let you know that I am marking this question as answered.

Kind regards,

Simon

Reply URL