Skip to Main Content

SQL & PL/SQL

How to find out difference between two time of the same day

User_8CW5LMay 29 2021

Hello Guys,
I came across one scenario of train station data; travelers tap in and tap out data in a day. I have two columns along with the date column one is TAP_IN (can say entering hour at the train station) and TAP_OUT (can say exit time from train station). Both columns are mentioning the only day/night time in 24HH: MM AM/PMformate. So how can I find out the difference in minutes between these two columns (difference between TAP_IN and TAP_OUT results into total minutes)?

This post has been answered by Hub Tijhuis on May 29 2021
Jump to Answer
Comments
Post Details
Added on May 29 2021
6 comments
534 views