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
- 7238 Views
- I also Faced
- E-Mail Answers
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
Which constraints we can use while creating database in sql?
How do you define a foreign key?
Explain cursor types?
What are its different types of dbms?
What are the different types of triggers?
Explain sql data types?
What is difference between sql function and stored procedure?
What is blind sql injection?
ERROR:Insert or update on table"accnt" violates foreign key constraints "acct_to_curr_symbol" DETAILS:KEY(accnt_curr_id)(-2)is not present in the table "curr_symbol" ......solve The Problem..
What is trigger types of trigger?
What is the best sql course?
What are the ways on commenting in a pl/sql code?
What do you mean by field in sql?
What is sql partition?
What is bulk collect in pl sql?
