How to read mysql datetime format?

To read datetime from mysql format to a format that we understand, simply just add from_unixtime(fieldname) on your query.

For example: select from_unixtime(lastaccess) from mdl_user;