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

Can we use threading in pl/sql?

1092


How can we connect an Android App to an Oracle database and use the PL/SQL procedural code?

1205


How to rename a column in the output of sql query?

1124


how to use in conditions? : Sql dba

1060


What are the string functions in sql?

1022


What is sql mysql pl sql oracle?

1128


What is dba in sql? : SQL DBA

1093


What are inner outer left and right joins in sql?

1058


Is inner join faster than left join?

1250


How do I truncate a word?

1159


What is information schema in sql?

1113


Why procedure is used in sql?

1084


What is schema in sql example?

1277


What is not equal in sql?

1192


How can the performance of a trigger be improved?

1087