COurse Start date and End date

COurse Start date and End date

by Reefo Relaxo -
Number of replies: 3
Hi, can somebody help me ? I'm not sure if this is where should I ask this. I'm trying to check in the Database where exactly is the Start Date of Course and Course End date can be found? And I looked into mdl_course table and saw a column that says startdate and enddate, but the data doesn't make sense to me. can somebody help me with this?
Average of ratings: -
In reply to Reefo Relaxo

Re: COurse Start date and End date

by Davo Smith -
Picture of Core developers Picture of Particularly helpful Moodlers Picture of Peer reviewers Picture of Plugin developers
Those are all Unix timestamps ( https://en.wikipedia.org/wiki/Unix_time ) - the number of seconds since midnight on the 1st Jan 1970 UTC. These are used throughout the Moodle database.

There are lots of ways to convert them into human-readable date / times, e.g. https://www.unixtimestamp.com/


In reply to Reefo Relaxo

Re: COurse Start date and End date

by Mark Sharp -
Picture of Core developers Picture of Particularly helpful Moodlers Picture of Plugin developers
If you're using mysql or mariadb you can use SELECT id, fullname, FROM_UNIXTIME(startdate) startdate, FROM_UNIXTIME(enddate) enddate FROM mdl_course;
Average of ratings:Useful (1)