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 vector point function?

1026


What is the purpose of primary key?

1003


What is pls_integer in pl sql?

1074


Does user triggers have entry for trigger with compilation errors?

1019


What is embedded sql what are its advantages?

1016


Why do we use set serveroutput on?

955


What are different types of queries in sql?

1103


How do I quit sql?

935


How do I know if I have sql express or standard?

1017


What is %rowtype in pl sql?

975


What is asqueryable?

951


What kind of join is join?

947


What do you mean by stored procedures? How do we use it?

982


What is having clause in sql?

947


Can we use delete in merge statement?

1030