Answer / zaheer

No,
you can store as (HH24:MI) at form level, also make format
DateTime.
Query by - to_date(HH24:MI)
Also you can use Timestamp - I tied it in Oracle 10g. It
will store date and time

Answer / nannesaheb c

There is no such data type is existed in Oracle to store the time in a column directly.

However we can insert the time value in a column using the sql functions as below.

SELECT substr(to_char(sysdate,'DD-MON-YYYY HH:MM:SS'),12,20) FROM dual;

create table time1
(
today_time varchar2(10)
);
insert into time1 values(substr(to_char(sysdate,'DD-MON-YYYY HH:MM:SS'),12,20));

Regards,
Nanne

What are the commands youd issue to show the explain plan for select

2 Answers  

---

Differentiate the standard purchase order,Blanket purchase agreement,Contract purchase agreement,Planned purchase order?

1 Answers  

---

What is a nested table and how is it different from a normal table?

0 Answers  

---

what is the difference between restoring and recovering?

0 Answers   MCN Solutions,

---

How to remove a row in a database table?

5 Answers   IBM,

---

You create a private database link and upon connection, fails with: ORA-2085: connects to . What is the problem? How would you go about resolving this error?

1 Answers  

---

Difference between pre-select and pre-query

0 Answers  

---

Explain the truncate in oracle?

0 Answers  

---

How to view existing locks on the database?

0 Answers  

---

How to delete multiple rows from a table in oracle?

0 Answers  

---

what is the difference between simple view and complex view?

13 Answers  

---

how to use select statement as formal parameter in procedure specification?(someone said that using string) ex:-procedure(a in number,select ename from emp ) i am asking syntax like this?

0 Answers   Sierra Atlantica,

---