3 years ago

Category: MySQL, api

I recently ran into an issue where I was getting integer value timestamp data from an API which I simply saved into an integer column of a table. The client I was working with then decided that they needed to the integer column of timestamps to be converted into human readable DateTime.

After Googling around for quite some time I finally found an answer that worked which I think is worth sharing.

In mysql t able run one of the following queries depending on your use case: You have a 10 digit timestamp value e.g.

Then FLOOR is appliedwhich converts the number to an integer (which is what we need in the next step) by rounding down.