Calculation Two Dates Time Difference

Calculation Two Dates Time Differences

I have seen several posts in OTN for calculation Tow dates time differences.


Solution:


cast(floor(TIMESTAMPDIFF(sql_tsi_second, "- SNP_SESSION".SESS_BEG, "- SNP_SESSION".SESS_END)/ 3600) as char) || ':' ||
cast(floor(mod(TIMESTAMPDIFF(sql_tsi_second, "- SNP_SESSION".SESS_BEG, "- SNP_SESSION".SESS_END),3600) /60)as char) || ':' ||
cast(mod(TIMESTAMPDIFF(sql_tsi_second, "- SNP_SESSION".SESS_BEG, "- SNP_SESSION".SESS_END),60) as char)


Please refer the below thread.

https://forums.oracle.com/forums/thread.jspa?threadID=2538182&tstart=0


Thanks,
Satya