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

What is the primary use of normalization?

986

When is a declare statement required?

1128

What do we need to check in database testing?

1004

Can we perform dml in function?

1050

What is difference between sql and oracle?

1098

How does index help in query performance?

1013

List the different type of joins?

1056

What is input buffer in sql*plus?

1192

Define commit?

980

What is a behavioral trigger?

961

State few characteristics of pl/sql?

963

what are date and time data types in mysql? : Sql dba

953

what is sp_pkeys? : Transact sql

1139

how can we destroy the session, how can we unset the variable of a session? : Sql dba

981

How do I run a sql trace?

946