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 are sql injection vulnerabilities?
What is parameter substitution in sql?
What is the order of sql select?
What is a null value?
What do you mean by dbms? What are its different types?
How to write a query to show the details of a student from students table whose
Mention what is the plv (pl/vision) package offers?
what are the type of locks ? : Sql dba
What is pl sql and why it is used for?
What is the difference between delete and truncate commands?
What is the default isolation level in sql server? : Transact sql
Why do we create views in sql?
what is the use of set statement in tsql? : Transact sql
What are stored procedures in mysql?
How is indexing done in search engines?