How to Calculate Difference between Two Dates for the Data Source created with MS SQL

To obtain the difference between two dates in days, hours, minutes, and seconds, you can use the following expression:

convert(varchar(5),DateDiff(s, 'start_date','end_date')/86400)+'d'+' '+convert(varchar(5),DateDiff(s, 'start_date','end_date')%86400/3600)+':'+convert(varchar(5),DateDiff(s, 'start_date','end_date')%3600/60)+':'+convert(varchar(5),(DateDiff(s, 'start_date','end_date')%60))

Replace the start_date and end_date with the actual dates you want to calculate the difference between.

Example

convert(varchar(5),DateDiff(s, '2017/08/24 06:00:00','2017/08/25 07:00:00')/86400)+'d'+' '+convert(varchar(5),DateDiff(s, '2017/08/24 06:00:00','2017/08/25 07:00:00')%86400/3600)+':'+convert(varchar(5),DateDiff(s, '2017/08/24 06:00:00','2017/08/25 07:00:00')%3600/60)+':'+convert(varchar(5),(DateDiff(s, '2017/08/24 06:00:00','2017/08/25 07:00:00')%60))