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 structural independence and why is it important?

978

What is db journal file?

952

Is sql a dbms?

937

List the ways to get the count of records in a table?

851

what is a table called, if it has neither cluster nor non-cluster index? What is it used for? : Sql dba

930

What is pls_integer in pl sql?

1027

What do you mean by “trigger” in sql?

1015

what are the differences between char and varchar? : Sql dba

1000

how many ways to get the current time? : Sql dba

947

What is the usage of sql functions?

1073

can sql servers linked to other servers like oracle? : Sql dba

947

Does access use sql?

964

Why we use join in sql?

911

what is a scheduled jobs or what is a scheduled tasks? : Sql dba

902

What are instead of triggers?

992