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 a temp table?
what happens if you no create privilege in a database? : Sql dba
What are the different sql commands?
Differentiate between pl/sql and sql?
How to use sql statements in pl/sql?
Is sql a scripting language?
If there are 1 to 100 numbers in a table and in that 100 numbers some 10 numbers are deleted.I want to find out the missing numbers between 1 to 100 by pl/sql how?
Why do we use procedures?
How does stored procedure reduce network traffic?
What programs use sql?
HOW TO ADD PRIMARY KEY TO TABLE BY PL/SQL PROGRAM
How can you create an empty table from an existing table?
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)