What will be the output

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

Posted by Rajnilari2015 on 11/2/2015 | Category: Sql Server Interview questions | Views: 2326 | Points: 40

Select from following answers:

2073600000
2419200000
2160000000
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.
All Above

Show Correct Answer

Asked In: Many Interviews | Alert Moderator

Bookmark It

< Previous : Which of the below command are equal to Select 1

Next > : What is the output ? RAISERROR ('dotnetfunda& ...

More Interview Questions by Rajnilari2015

Latest Interview Questions