Converting Unix timestamp

I have a column of data that I would like to convert form Unix to regular date form. 

Does anyone know how to do this by either creating a new column or converting the data?

Thanks

1reply Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
  • Hi Carter Burleson ,

     

    Thanks for writing into the Mode Forum! Depending on the database, there are a few possible ways to convert Unix time to a datetime format. Here is a post on Stack Overflow that details a few ways to achieve that result. 

     

    Feel free to write into our In-App Support Channel if you have more questions around SQL. 

     

    Best,
    Jonathan 

    Like
Like Follow
  • 5 mths agoLast active
  • 1Replies
  • 48Views
  • 2 Following