Without knowing what the freezer fixture looks like, freezegun has a few helpful options:

• The timezone can be set to debug the issue with the offset for the hours
• The context manager can be used within the test to check that the time is being correctly moved to the given datetime

@pytest.mark.asyncio
async def test_login__authorize__check_log_date(session):
    # Arrange
    await push_one_user()
    payload = {USERNAME_KEY: USER_LOGIN, PASSWORD_KEY: PLAIN_PASSWORD}

    with freeze_time(year=2025, month=7, day=29, hour=7, minute=19, second=16, tick=False, tz_offset=0):
        # Act
        await execute_post_request("/auth/login", payload=payload)

        # Assert
        last_log = (await get_user_log(session)).pop()
        assert last_log.date_connexion == datetime.now()