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
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / sushant kumar
select sum(to_number(substr(num,1,2))) ||':'||
sum(to_number(substr(num,4,2))) ||':'||
sum(to_number(substr(num,7,2)))
from tt
Is This Answer Correct ? | 3 Yes | 1 No |
Answer / avi007
select sum(hiredate,'hh') ||':'|| sum(hiredate,'mm')
||':'|| sum(hiredate,'ss') from emp;
Is This Answer Correct ? | 1 Yes | 3 No |
what is timestamp in mysql? : Sql dba
Which function is used to return remainder in a division operator in sql?
wht is the difference between sqlaserver2000 and 2005
What does count (*) do in sql?
how can I make a script that can be bi-language (supports english, german)? : Sql dba
How do rank () and dense_rank () differ?
What does the base_object_type column shows in the user.triggers data dictionary view?
What is nvarchar max in sql?
What is group by in sql?
How many databases can sql express handle?
What do you mean by rowid?
what is the difference between union and union all? : Sql dba