CREATE TABLE vacation_users(EMAIL VARCHAR(255), STARTDATE DATE, ENDDATE DATE);

SELECT * FROM vacation_user WHERE (ENDDATE < (SYSDATE + 2 DAY));

select email
from vacation_users
where startdate < sysdate - 2;

SELECT EMAIL from vacation_users
    WHERE ENDDATE < DATEADD(day, +2, CURRENT_DATE) AND ENDDATE > GETDATE()

SELECT *
FROM vacation_users
WHERE (DATEADD(day,2,ENDDATE)) < (CONVERT(date, SYSDATETIME()))