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
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
select FROM_UNIXTIME(last_login) from oc_accounts;
that simple
ty
1 Like