WEEK_ADD YEAR_ADD MINUTE_ADD SECOND_ADD

While there are:

DATE_ADD - which adds days to a date (though seems like it should be called DAY_ADD, and
MONTH_ADD - which adds months to a date

There is no WEEK_ADD or YEAR_ADD

Both can be done with multiples of DATE_ADD * 7 or MONTH_ADD * 12 but this leads to code that is not particularly clear to read.

Please add
WEEK_ADD and
YEAR_ADD as functions.

EDIT:
MINUTE_ADD AND
SECOND_ADD are also missing

Minutes are also missing (MINUTE_ADD)

And while we are here, SECOND_ADD is also missing

+1 for MINUTE_ADD. I am doing some detailed scheduling and need it accurate to the minute. So fractions of HOUR_ADD don't cut it.

Bruce