In which of the following scenarios is the DATE_ADD function the optimal date function to use? Select ALL that apply.

1. To find values in the last 30 days
2. To find values in the last month.
3. To add or subtract a certain number of days from a given date
4. To find values in a given week.
5. To find values between the start of last month, and the end of the current month

Correct Answer:

• To find values in the last 30 days
• To add or subtract a certain number of days from a given date