MARIADB date format

Hello

I have difficulty transforming the date formats in the database … example table oc_account - lastlogin (1,566,909,902).
I researched how to convert and unfortunately what I found I could not understand.

thank you


https://www.epochconverter.com/

Hello,

I’m not sure to understand your question quite well. The format of last_login is a simple timestamp.
For example using MySQL you can do as follow:

mysql> select FROM_UNIXTIME(last_login) from oc_accounts;
+---------------------------+
| FROM_UNIXTIME(last_login) |
+---------------------------+
| 2019-08-26 18:33:23       |
| 2019-06-03 20:20:27       |
| 1970-01-01 01:00:00       |
+---------------------------+
3 rows in set (0.00 sec)
1 Like

:man_facepalming::man_facepalming:
select FROM_UNIXTIME(last_login) from oc_accounts;

that simple :man_facepalming:

ty

1 Like