Question discussion

Which of the following statement is correct for DATEDIFF function in SQL?I. This function reports difference between the arguments ‘startda…

3480Medium DSSSB TGT Computer Science 0 replies

Which of the following statement is correct for DATEDIFF function in SQL?

I. This function reports difference between the arguments ‘startdate’ and ‘enddate’.

II. In this, ‘datepart’ argument/value can be specified in a variable.

  • AOnly I
  • BNeither I nor II
  • CBoth I and II
  • DOnly II
Correct answer: A

Explanation

DATEDIFF reports the difference between startdate and enddate (I is true). The datepart cannot be given as a variable (II is false).

Discussion 0

Nobody has replied yet. Start the discussion!