MySQL date_sub Query employee information for seniority greater than 35

# (11) Find employee information that is greater than or equal to 35 years of seniority.
SELECT * from emp e WHERE e.hiredate<=date_sub (Sysdate (), INTERVAL);

Date_sub Syntax:

Date_sub (Date,interval expr type)

The date parameter is a valid day expression. The expr parameter is the time interval that you want to add.

Type value
Microsecond
SECOND
MINUTE
HOUR
Day
WEEK
MONTH
QUARTER
Year
Second_microsecond
Minute_microsecond
Minute_second
Hour_microsecond
Hour_second
Hour_minute
Day_microsecond
Day_second
Day_minute
Day_hour
Year_month

MySQL date_sub Query employee information for seniority greater than 35