Getting half hour intervals from Time field
hi guys
I have a field containing time, Char(6) looking like 151249 - for 12 minutes past 3 and 49 seconds
I need to deduct the half hour from that field. So for 151249, it would need to be 15:00
if the time was 153112, it would need to be 15:30 (always round to the nearest half hour)
Can anyone assist me how to do this?
Much appreciated
Subject
Written By
Posted
Getting half hour intervals from Time field
June 25, 2018 11:10PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.