sql - Date Difference Query -

sql - Date Difference Query -

my database has table in has 2 date columns (start date , end date)

how can list dates difference of start date , end date no more 15 days?

this tried far:

select homeworkid, subject, startdate, dateadd(day,15,startdate) enddate homework;

just add together filter predicate per rule/logic :

select start_date, end_date, other_columns table end_date - start_date <= 15

sql oracle oracle11g sos