troubleshooting Question

How do I add (duration) for start Date and Time in Oracle 10G?

Avatar of shwanhamawandi
shwanhamawandiFlag for Iraq asked on
Oracle Database
7 Comments3 Solutions2220 ViewsLast Modified:
I have a table on Oracle 10g, with three columns ( Duration, start_date, start_time) as show below, I want to add two other columns contain stop_date and stop_time (by adding the duration to start_date and time)... Is there any way to implement such issue in Oracle 10g

Duration(sec)                start_date         start_time                                  stop_date         stop_time
- - - - - - - - - -               - - - - - - - -        - - - - - - -                                  - - - - - - - - -      - - - - - - -
620                              2008-07-11        09:15:36     >>>> should be       2008-07-11       09:25:56        
1118                            2008-07-14        16:55:22     >>>> should be       2008-07-14       17:14:00
259                             2008-07-20         23:58:43     >>>> should be       2008-07-21        00:03:02  

THANKS    
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 3 Answers and 7 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 3 Answers and 7 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros