COurse Start date and End date

COurse Start date and End date

oleh Reefo Relaxo -
Jumlah balasan: 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?
Rata-rata penilaian: -
Sebagai balasan Reefo Relaxo

Re: COurse Start date and End date

oleh Davo Smith -
Gambar dari Core developers Gambar dari Particularly helpful Moodlers Gambar dari Peer reviewers Gambar dari 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/


Sebagai balasan Reefo Relaxo

Re: COurse Start date and End date

oleh Mark Sharp -
Gambar dari Core developers Gambar dari Particularly helpful Moodlers Gambar dari 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;
Rata-rata penilaian:Useful (1)