Loading

Date Difference

Archit Shrivastava

7y760

How to calculate date diffrence with time

i have fromdate and Todate and i want to calculate diffrence between date with time

EX:- 10 1:02:03(day hh:mm:ss)

2 Replies

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

Jignesh Kumar7y ago
Accepted answer
Hi Archit,

Please find below link,
https://social.msdn.microsoft.com/Forums/sqlserver/en-US/5e5a4474-31b8-4316-8a34-1e4a5572fb49/date-difference-in-dayshours-minutes-and-seconds?forum=transactsql
0
Guest User7y ago
See DATEDIFF()

https://docs.microsoft.com/en-us/sql/t-sql/functions/datediff-transact-sql
0