Skip to Main Content
Forums

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!

Select a list of hours of the day (in 30-minute increments)?

Andrew VJun 20 2017 — edited Jun 20 2017

I need to generate an LOV which lists times of day in 30-minute increments. For example:

DisplayReturn
8.00am08:00
8.30am08:30
9.00am09:00
9.30am09:30
10.00am10:00
...and so on
5.00pm17:00
5.30pm17:30
6.00pm18:00

I presume it must be possible to generate this list on-the-fly and lot have a literal table of possible values. I've been searching for the answer and thought the INTERVAL function might be what I'm after, but that seems to require source data to split-up into slices.

Anyone have any suggestions?
This post has been answered by Frank Kulash on Jun 20 2017
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 18 2017
Added on Jun 20 2017
2 comments
2,434 views