Real Shell Creation Dates (Query)

Real Shell Creation Dates (Query)

by Christopher Esbrandt -
Number of replies: 0

My apologies if I'm posting this in the wrong section.

Is it possible to retrieve the legitimate creation date for a course shell? I know the database stored creation dates and modified dates, but these dates inherit from backup files when a shell is created from a backup. Is it possible to retrieve the actual creation dates of the shell and not that of the shell the backup used to create it came from?

I've tried using:

SELECT id, shortname, FROM_UNITTIME(timecreated) AS timecreated
FROM mdl_course;

The issue is exactly as I identified above: all shells created off a backup (we have a master skeleton for formatting purposes) have identical creation dates matching that which corresponds to the creation of the skeleton.

Average of ratings: -