Basit Khan

Basit Khan

  • 1k
  • 336
  • 115.3k

How to get number of days in between two dates

Mar 14 2016 7:26 AM
Dear,
How to get number of days in between two dates</pre>
I tried below query in SQL.
 
select DATEDIFF(DAY,'2016-03-11 12:00','2016-03-13 20:00')
its right but i want in decimal format.
Thanks
Basit

Answers (3)