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 |
Why do we use joins in sql?
Explain the uses of database trigger.
What is ON DELETE CASCADE?
When can we use the where clause and the having clause?
hello..... i am an comp science engineering graduate planning to do ORACLE certification in PLSQL 9i. just wanted to know whats the possibility getting job is their openings???? is it worth doin that course n certification
define sql
Can we call procedure in select statement?
What is dense_rank?
Is id a reserved word in sql?
how to eliminate null values in a column i.e table vlaues 1 2 3 NULL 3 4 1 5 NULL i want output like this 1 2 3 3 4 1 5 i dnt want to use nvl is null and i dnt want replace the NULL value with any value i.e nvl(col,o);
Authentication mechanisms in Sql Server ?
What is difference between CHAR and VARCHAR2?What is the maximum SIZE allowed for each type?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)