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 union and union all? : Sql dba

1021


Can we commit in trigger?

979


How do you optimize a stored procedure in sql?

960


GLOBAL TEMPORARY TABLE over Views in advantages insolving mutating error?

3052


What is embedded sql with example?

1056


What are sql objects?

1082


What is a native sql query?

1078


Does truncate table reset auto increment?

998


What are the different dcl commands in sql?

1176


What is indexing oracle sql?

1108


What are the types of operators available in sql?

1066


Is it possible to remove child records without removing master table records...the two having pk,fk relationship?

1269


Why is partition used in sql?

1127


Is sql easier than java?

1018


Enlist the advantages of sql.

1002