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 are the features of pl sql?

1015

Can a table have no primary key?

1011

Why commit is not used in triggers?

994

How do you create a unique index?

992

What is on delete restrict?

945

How do you exit in sql?

1065

What does over partition by mean in sql?

923

Can we create clustered index without primary key?

901

What is oracle pl sql developer?

936

What is transaction control language (tcl)?

1074

How to take user input in pl sql?

1107

Is sql harder than python?

1039

what is table? : Sql dba

994

Is left join and outer join same?

1006

What is the difference between delete and truncate commands?

978