Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback, please email oracle-forums_moderators_us@oracle.com

Add hours and minutes in char column

SHR_ORACJan 9 2018 — edited Jan 9 2018

Hi

i hv a char column A

i have time stored in that column like 09:45, 10:01 etc.

Now i want to derive a new column B by adding 08:30 i.e 8 hours and 30 mins.

pls help..

This post has been answered by mathguy on Jan 9 2018
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 6 2018
Added on Jan 9 2018
17 comments
1,755 views