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...

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

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between function, procedure and package in pl/sql?

1132


how to dump a table to a file with 'mysqldump'? : Sql dba

981


What are tables and fields in the database?

1022


what are the t string functions available in tsql? : Transact sql

944


What are the advantages of sql?

1005


What is cold data?

897


What do you think about pl/sql?

944


What are user defined functions?

946


what is the difference between delete and truncate statement in sql? : Sql dba

1123


What does <> sql mean?

984


What is the difference between an inner join and an outer join?

966


What is sql query limit?

907


What is sql and explain its components?

1006


What are different joins used in sql?

1007


What is user in sql?

966