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 vector point function?

1095

What are the various restrictions imposed on view in terms of dml?

1017

What is the execution plan in sql?

1070

How can I make sql query run faster?

1067

what is dbms? : Sql dba

1036

How to display the current date in sql?

1129

What is range partitioning?

1014

what is error ora-03113: end-of-file on communication channel?

1226

How do I restart sql?

1026

Is pl sql a programming language?

1044

What is difference between left and right outer join?

1038

What are the constraints available in sql?

1086

Explain the uses of control file.

1100

Can a foreign key have a different name?

996

Can a table have no primary key?

1110