Which of the following is not a valid way to avoid search problems when you want

Question

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 and which might include time values(in MS sql server)?

Select one:

a. convert each datetime value to a date value

b. search for datetime values that fall between the day before and the day after the date you want

c. use the Day, Month, and Year functions to do the search

d. use the DatePart function to extract just the date from each datetime value

Explanation / Answer

d. Use the DatePart function to extract just the date from each datetime value

Related Questions

Navigate

• Browse (All)
• Browse W
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.