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
What is the difference between function, procedure and package in pl/sql?
how to dump a table to a file with 'mysqldump'? : Sql dba
What are tables and fields in the database?
what are the t string functions available in tsql? : Transact sql
What are the advantages of sql?
What is cold data?
What do you think about pl/sql?
What are user defined functions?
what is the difference between delete and truncate statement in sql? : Sql dba
What does <> sql mean?
What is the difference between an inner join and an outer join?
What is sql query limit?
What is sql and explain its components?
What are different joins used in sql?
What is user in sql?