id

SELECT course, FROM_UNIXTIME( timemodified ) FROM mdl_assign

SELECT id, FROM_UNIXTIME( timemodified ) FROM mdl_course

select course,FROM_UNIXTIME( timemodified ) FROM  mdl_feedback

select course,FROM_UNIXTIME( timemodified ) FROM  mdl_folder

SELECT courseid, FROM_UNIXTIME( timemodified ) FROM  `mdl_event`

select course,,FROM_UNIXTIME( timemodified ) from mdl_quiz


SELECT course, FROM_UNIXTIME( TIME )
FROM mdl_log
WHERE ACTION =  'update'
AND module =  'course'


select course,,FROM_UNIXTIME( timemodified ) from mdl_quiz

SELECT *,FROM_UNIXTIME(timemodified) FROM `mdl_event`