Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

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 / vijay bhaskar

Answers were Sorted based on User's Feedback



how to insert values like 10:10:00,30:25:00 etc.into table after insert how can i sum the above in..

Answer / gourvendra singh

Buddy i have did this thru the D2k, while creating the
column with the datatype varchar2 and put the format of the
field on the form level as the time format. this will
convert the time in seconds and store in the database.for
ex ur 1:00 will store as 3600 in the database

Is This Answer Correct ?    2 Yes 0 No

how to insert values like 10:10:00,30:25:00 etc.into table after insert how can i sum the above in..

Answer / sushant kumar

select sum(to_number(substr(num,1,2))) ||':'||
sum(to_number(substr(num,4,2))) ||':'||
sum(to_number(substr(num,7,2)))
from tt

Is This Answer Correct ?    3 Yes 1 No

how to insert values like 10:10:00,30:25:00 etc.into table after insert how can i sum the above in..

Answer / avi007

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

Is This Answer Correct ?    1 Yes 3 No

Post New Answer

More SQL PLSQL Interview Questions

What is a temp table?

0 Answers  

what happens if you no create privilege in a database? : Sql dba

0 Answers  

What are the different sql commands?

0 Answers  

Differentiate between pl/sql and sql?

0 Answers  

How to use sql statements in pl/sql?

0 Answers  

Is sql a scripting language?

0 Answers  

If there are 1 to 100 numbers in a table and in that 100 numbers some 10 numbers are deleted.I want to find out the missing numbers between 1 to 100 by pl/sql how?

9 Answers   JPMorgan Chase,

Why do we use procedures?

0 Answers  

How does stored procedure reduce network traffic?

0 Answers  

What programs use sql?

0 Answers  

HOW TO ADD PRIMARY KEY TO TABLE BY PL/SQL PROGRAM

3 Answers  

How can you create an empty table from an existing table?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories