Difference in Timestamps in seconds

Analytics
Enthusiast

Difference in Timestamps in seconds

Can anyone provide me solution for timestamp difference in seconds.

 

t1 = 4/15/2017 17:34:52

t2 = 4/16/2017 18:43:54

t2 - t1 = 86400+3600+540+ 2 =90542 seconds

 

i know that if we subtract timestamps we will get 

('4/17/2017 10:43:17'- '4/15/2017 17:34:52') DAY(4) TO SECOND as diff the answer is    1 17:08:25.000000. But im looking for some solution that give me caluculated value in Seconds.

 

Thanks in advance.