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!

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

688396
Error is taken from this command....

Provider p = new sun.security.pkcs11.SunPKCS11(configName);
1 - 1

Post Details

Added on Jun 23 2021
6 comments
307 views
1 mention