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 vector point function?
What is the purpose of primary key?
What is pls_integer in pl sql?
Does user triggers have entry for trigger with compilation errors?
What is embedded sql what are its advantages?
Why do we use set serveroutput on?
What are different types of queries in sql?
How do I quit sql?
How do I know if I have sql express or standard?
What is %rowtype in pl sql?
What is asqueryable?
What kind of join is join?
What do you mean by stored procedures? How do we use it?
What is having clause in sql?
Can we use delete in merge statement?