In SQL Server, the right way of comparing datetimes by date only is this:
... WHERE AttendanceRegister.RegistrationDate >= GETDATE() AND AttendanceRegister.RegistrationDate < dateadd(day, 1, GETDATE())