Cannot access Web/admin/manage_reservations.php if database is MySQL 8

Accessing  Web/admin/manage_reservations.php after logging in, if the database is MySQL 8 results in an unknown error.
After checking all logs, the error comes from the following piece of sql ( (`ri`.`checkin_date` IS NULL OR `ri`.`checkin_date` = '') ) that causes an 1525 error, Incorrect datetime
