Index: lams_common/src/java/org/lamsfoundation/lams/lesson/dao/hibernate/LessonDAO.java =================================================================== diff -u -r976df526805398d7daa7d49e4e11b81272ec3cb5 -r234d7ab100d056b8846c5b8ba00706a4b434accf --- lams_common/src/java/org/lamsfoundation/lams/lesson/dao/hibernate/LessonDAO.java (.../LessonDAO.java) (revision 976df526805398d7daa7d49e4e11b81272ec3cb5) +++ lams_common/src/java/org/lamsfoundation/lams/lesson/dao/hibernate/LessonDAO.java (.../LessonDAO.java) (revision 234d7ab100d056b8846c5b8ba00706a4b434accf) @@ -110,7 +110,7 @@ + ") AS absolute_time_limit " + "FROM lams_lesson AS l JOIN lams_learning_activity AS a USING (learning_design_id) " + "WHERE l.lesson_id = :lessonId AND a.tool_content_id IS NOT NULL " - + "HAVING absolute_time_limit > NOW() ORDER BY absolute_time_limit"; + + "HAVING absolute_time_limit > UTC_TIMESTAMP() ORDER BY absolute_time_limit"; /** * Retrieves the Lesson. Used in instances where it cannot be lazy loaded so it forces an initialize.