How to get number of days in between two dates

Basit Khan

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

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Vijay Saklani10y ago
Hi basit,

Check this one:

Get number of days between two dates:Get date

thanks
0
Sateesh Arveti10y ago
select DATEDIFF(hour,'2016-03-11 12:00','2016-03-13 20:00')/24.0 =2.333
0

Hey,try 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