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
Can we use threading in pl/sql?
How can we connect an Android App to an Oracle database and use the PL/SQL procedural code?
How to rename a column in the output of sql query?
how to use in conditions? : Sql dba
What are the string functions in sql?
What is sql mysql pl sql oracle?
What is dba in sql? : SQL DBA
What are inner outer left and right joins in sql?
Is inner join faster than left join?
How do I truncate a word?
What is information schema in sql?
Why procedure is used in sql?
What is schema in sql example?
What is not equal in sql?
How can the performance of a trigger be improved?