how to insert values like 10:10:00,30:25:00 etc.into table after insert how ca

how to insert values like 10:10:00,30:25:00 etc.into table
after insert how can i sum the above insert values to get
the result as 40:35:00

Question Posted / vijay bhaskar

3 Answers
7235 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

how to insert values like 10:10:00,30:25:00 etc.into table after insert how can i sum the above in..

Answer / gourvendra singh

Buddy i have did this thru the D2k, while creating the
column with the datatype varchar2 and put the format of the
field on the form level as the time format. this will
convert the time in seconds and store in the database.for
ex ur 1:00 will store as 3600 in the database

Is This Answer Correct ?

2 Yes

0 No

how to insert values like 10:10:00,30:25:00 etc.into table after insert how can i sum the above in..

Answer / sushant kumar

select sum(to_number(substr(num,1,2))) ||':'||
sum(to_number(substr(num,4,2))) ||':'||
sum(to_number(substr(num,7,2)))
from tt

Is This Answer Correct ?

3 Yes

1 No

how to insert values like 10:10:00,30:25:00 etc.into table after insert how can i sum the above in..

Answer / avi007

select sum(hiredate,'hh') ||':'|| sum(hiredate,'mm')
||':'|| sum(hiredate,'ss') from emp;

Is This Answer Correct ?

1 Yes

3 No

Post New Answer