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 the difference between to_char and to_date functions?

10 Answers   Infosys,

How many database objects (trigger, packages, sequence etc) uses a particular field in a given table. For ex: I want to know how many database object uses the ATTRIBUTE1 in the PO_VENDORS table. What query will give me the result showing the database object name(package, trigger etc), field_name used (in this case ATTRIBUTE1) and table_name (in this case PO_VENDORS).

2 Answers   IBM,

How to load data with sql*loader?

0 Answers  

What are the types of sql commands?

0 Answers  

What are its different types of dbms?

0 Answers  

What are nested triggers ?

6 Answers   Amazon, Appeal Soft, IBM, Infosys, TCS,

Where the Pre_defined_exceptions are stored ?

2 Answers  

What is the difference between DELETE, TRUNCATE, and DROP?

3 Answers  

What is cursor status?

0 Answers  

What is the most common sql injection tool?

0 Answers  

While inserting/updating million of records into a database table, how do I came to know how many records has been inserted or updated successfully so far?

2 Answers   HSBC,

What is the difference between joins?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories