How do i perform a calculation based on a specific time of the day in Oracle?
Posted on 2012-03-31
I would like to calculate the minutes in Oracle if the time passes 1530. I am having trouble with the best way to hard code time time and cacalulate
Thanks so much!
TO_CHAR(ptoutor.tracking_time_in ,'hh24mi') > '1530'
(15:30?? - ptinor.tracking_time_in ) * 1440
(ptoutor.tracking_time_in - ptinor.tracking_time_in ) * 1440