How to resize quiz timer box

On a 1024x768 resolution, the quiz timer box sometimes block the questions. To resize the box, edit the moodle/mod/quiz/jstimer.php

Look for width on the first "table" and change 150px to 80px. That should fix the problem.

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;