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!

Adding hours to a date

user5716448Jun 23 2021

Hi,

version 11.2

Have a date column and need to look up another table which has two columns both varchar2
example

date

23/06/2021

table looking up has start 18:00 and extra 00:10

need to add bot these to existing one such that result would be 23/06/2021 18:10

How is this best achieved?

Thanks

Comments
Post Details
Added on Jun 23 2021
6 comments
290 views