An example SELECT username, FROM_UNIXTIME(timecreated, "%Y-%m-%d") AS RegisteredDate FROM mdl_user;
General developer forum
Databases: Conversion from bigint to date
This discussion has been locked so you can no longer reply to it.
An example SELECT username, FROM_UNIXTIME(timecreated, "%Y-%m-%d") AS RegisteredDate FROM mdl_user;