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
- 3 Answers
- 7239 Views
- I also Faced
- E-Mail Answers
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 does trigger mean in psychology?
Which is better cte or subquery?
how to present a past time in hours, minutes and seconds? : Sql dba
What is a primary key example?
How do I run a sql script?
What is the use of non clustered index?
Explain the difference in execution of triggers and stored procedures?
What is the need of a partition key?
When sql appeared?
what are the authentication modes in sql server? How can it be changed? : Sql dba
What is pl sql package?
How bulk collect improves performance?
What is insert command in sql?
What is indexing in sql and its types?
What are the different sql languages?
