Time difference between two columns storing only time in SQL
I have two columns (session_starttime & session_endtime) whose data type is a text. As seen in the image, it is only the time part that is stored and no date. I am struggling to get a session duration in seconds. The ultimate goal is to get the average time per session. I have tried the…