Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

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
1,079 views