Which of the following is not a valid way to avoid search problems when you want to search for rows that have a specific date in a column that's defined with the DATETIME data type?
Select one:
a. use the MONTH, DAYOFMONTH, and YEAR functions in the WHERE clause to search for just those components
b. search for a range of dates that are greater than or equal to the date you're looking for, and less than the date that follows the date you're looking for
c. use the DATE_FORMAT function in the WHERE clause to return a formatted string that only contains the month, day, and year
d. use the DATE_ADD function to remove the time values from the dates in each column
