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

Answer 1

Answer:

Option D is the correct answer to the following question.

Explanation:

Because in the MS SQL server, the DatePart function is an invalid type of way to stay away from the search problem because it is used to remove date from the date and time value. So, that's why it is not a valid way for the search problems when anyone want to search for the rows or the columns that have a particular date which includes the time values.