How to get number of days in between two dates

Question

Dear How to get number of days in between two dates 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

Vijay Saklani · Answer

Hi basit Check this one: Get number of days between two dates:Get date thanks

Sateesh Arveti · Answer

select DATEDIFF(hour'2016-03-11 12:00''2016-03-13 20:00')/24.0 =2.333

Amit Singh · Answer

Heytry this 1.SELECT DATEDIFF(DAY'2016-03-11''2016-03-13') 2.http://stackoverflow.com/questions/11418496/how-to-find-the-number-of-days-between-two-dates