How to Backdate Course and Log data

Re: How to Backdate Course and Log data

Tim Hunt -
Erantzun kopurua: 1
Core developers-ren irudia Documentation writers-ren irudia Particularly helpful Moodlers-ren irudia Peer reviewers-ren irudia Plugin developers-ren irudia
In Moodle, dates are stored in the database as Unix timestamps. That is, number of second since 1970-01-01 00:00:00 UTC. They are the displayed in the time-zone of whichever user is logged in (which is set in each user's user profile).

If you have direct access to the database, you could adjust all the times in key tables by applying a offset to all the relevant columns like logstore_standard_log.timecreated - but there are quite a lot of time-related columns. You probably need to look through the DB scheme, and find all the columns with 'time' in the name.
Puntuazioen batez bestekoa:Useful (2)