What will be the output

SELECT DATEDIFF (ms,GETDATE()-25,GETDATE()) ?

 Posted by Rajnilari2015 on 11/2/2015 | Category: Sql Server Interview questions | Views: 461 | Points: 40
Select from following answers:
  1. 2073600000
  2. 2419200000
  3. 2160000000
  4. Msg 535, Level 16, State 0, Line 1 The datediff function resulted in an overflow. The number of dateparts separating two date/time instances is too large. Try to use datediff with a less precise datepart.
  5. All Above

Show Correct Answer


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response