How to convert unix timestamp to date/time

Hi @chelminski,

Is this from a Data Table? May we know what data source you’re using (table/view or custom query).

If the data source is a custom query, you can use SQL statements to convert from UNIX time. Here’s a guide: How to Convert a Unix Timestamp to a Date/Time in SQL (database.guide)

Hope this helps! Let us know if you have more questions.

Sorry, I don’t quite understand, can you explain it a bit more? I’m very new to these things. How could I implement such a modified query into a plugin? I am creating a table where the data source is sql.

Hi @chelminski,

Could you link us to the page for this table so we can check?

You can also send us a message at Contact | WP Data Access so we can assist you better.

We’ll wait for your response! ??

Sure

TEST PAGE

Password: tab

P.S. Also the website was restored so in this case the date of registration for all will indicate the same day ??

• This reply was modified 1 year, 6 months ago by chelminski.

Hi @chelminski,

Thanks!

Is the table’s data source an existing table in your database, or is it from a custom query?

This is what I mean by data source: https://share.getcloudapp.com/WnumPrKe

If it’s a custom query, you can use the SELECT FROM_UNIXTIME statement on your Reg Date column. Reference here: MySQL :: MySQL 8.0 Reference Manual :: 12.7 Date and Time Functions

If you need help with this, please message us at Contact | WP Data Access.

Let us know how it goes. ??

Hi there,

Since there hasn’t been any recent activity in this thread, I’m going to mark this as resolved.

Feel free to create a new thread if you have other questions.

Thanks!