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 union and union all? : Sql dba
Can we commit in trigger?
How do you optimize a stored procedure in sql?
GLOBAL TEMPORARY TABLE over Views in advantages insolving mutating error?
What is embedded sql with example?
What are sql objects?
What is a native sql query?
Does truncate table reset auto increment?
What are the different dcl commands in sql?
What is indexing oracle sql?
What are the types of operators available in sql?
Is it possible to remove child records without removing master table records...the two having pk,fk relationship?
Why is partition used in sql?
Is sql easier than java?
Enlist the advantages of sql.