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
Answer Posted / 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 |
Post New Answer View All Answers
What is data manipulation language?
How do I find duplicates in the same column?
Explain the select statement in sql?
Who developed sql?
which command using query analyzer will give you the version of sql server and operating system? : Sql dba
What is a temporal data type?
Where are my tempfiles, I don't see them in v$datafile or dba_data_file?
What will you get by the cursor attribute sql%notfound?
What is the non-clustered index in sql?
What is sql and its types?
What is the difference between left join and right join?
How do we accept inputs from user during runtime?
what is the difference between primary key and unique key? : Sql dba
How to install oracle sql developer?
Is sql pronounced sequel or sql?