For one of the course enrolments, the Edit Enrolment screen shows the Enrolment Start date as 17 May 2023 15:41. In the ENROL.TIMECREATED field it is stored as 1491275765. When converting this Unix Time to date/time, it converts to 4 April 2017 3:16:05 AM (GMT) / 4 April 2017 3:16:05 PM (GMT+12:00). Why are the dates different? Am I looking at the wrong table/field in the database?
What are the time zones of your server / php / admin user?
It is set to Australia (Sydney).
Are you sure that that student doesn't actually two enrollment methods?
Only one enrolment method is available to the student.
I was looking at the wrong field. I needed to look at the USER_ENROLMENTS table, not the ENROL table.