Skip to Main Content

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 only hour and minute from datetime value

user560737Oct 19 2020 — edited Oct 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

Comments
Post Details
Added on Oct 19 2020
1 comment
930 views