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

✅  The correct answer is:

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

Question:

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

Solution:

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