MySQL Forums
Forum List  »  Newbie

Getting half hour intervals from Time field
Posted by: Lorna Louw
Date: June 25, 2018 11:10PM

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

Options: ReplyQuote


Subject
Written By
Posted
Getting half hour intervals from Time field
June 25, 2018 11:10PM


Sorry, only registered users may post in this forum.

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.