select sum(hiredate,'hh') ||':'|| sum(hiredate,'mm

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

Question Posted / avi007

Answer Posted / avi007

select sum(hiredate,'hh') ||':'|| sum(hiredate,'mm')
||':'|| sum(hiredate,'ss') from emp;

Is This Answer Correct ?

1 Yes

3 No

Please Help Members By Posting Answers For Below Questions

how to get help information from the server? : Sql dba

949

How does sql profiler work?

1023

Why do we use procedures in sql?

1093

What is sql profiler in oracle?

1101

How to fetch alternate records from a table?

1253

Explain what is sql?

1121

How does join work in sql?

1021

What are the uses of sysdate and user keywords?

1105

What is a primary key called that is made up of more than one field?

1356

What action do you have to perform before retrieving data from the next result set of a stored procedure ?

2580

What is lexical units in pl sql?

1155

What are schema-level triggers?

1107

Can we create table inside stored procedure?

964

What is varray in pl sql?

1085

What is composite primary key in sql?

1005