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!

Compare hour and minute from datetime columns

user560737Oct 19 2020

Hello to all
I have a table with date time column ex
16/10/2020 08:00:00
17/10/2020 08:30:00
18/10/2020 10:20:00

How I can to select only and exclusively some rows by giving an input of the type
19/10/2020 08:50
does not matter the day (19/10/2020) but only hours and minutes?
In my example
I want get only 3th (18/10/2020 10:20:00)
Thank you to all in advance

I'll try to to_timestamp and cast Bu I no success

This post has been answered by Solomon Yakobson on Oct 19 2020

Jump to Answer

Added on Oct 19 2020

16 comments

14,700 views