SQL Timezone issue

SQL Timezone issue

by Nilesh Pathade -
Number of replies: 0

I am using configurable report to get data of student and course who completed courses. 

But In my case, One of the student given exam on dated 25 may 2018 22:50:02 . But report showing 26 may 2018 in my report.

Moodle Default timezone is : America/Phoenix

Student timezone : America/Phoenix

[ I have check database entry and there is course_completion table value of timecompleted is 1527313802 for that student ]

I have convert this 1527313802  online it's 25th may.

Help me out. It's very urgent.


Average of ratings: -