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 / avi007
select sum(hiredate,'hh') ||':'|| sum(hiredate,'mm')
||':'|| sum(hiredate,'ss') from emp;
Is This Answer Correct ? | 1 Yes | 3 No |
Post New Answer View All Answers
What are different types of sql commands?
What is materialized view in sql?
What type of join is sql join?
What is pragma in sql?
What does the file extension accdb stand for?
Is delete faster than truncate?
What is the process of copying data from table a to table b?
Can we delete column in sql?
how can we destroy the cookie? : Sql dba
How to return an array from java to pl/sql?
What is memory optimized table?
What is execute immediate?
How many subqueries can be nested in a statement?
What is pl sql block structure?
How do I count rows in sql?