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 is difference between DBMS and RDBMS?

2 Answers   Metric Stream,

---

What privilege is needed for a user to connect to oracle server?

0 Answers  

---

why dont we assign not null constraint as table level constraint.

0 Answers  

---

How to call a trigger inside a stored procedure?Give an example.

2 Answers  

---

What is the purpose of tables, private synonyms and public synonyms in Oracle?

0 Answers   HCL,

---

Describe Referential Integrity ?

1 Answers  

---

What are the different types of modules in oracle forms?

0 Answers  

---

Hi Masters, in Oracle Applications 11i, we hace 2 functions using the same form, i need to create 1 personalization, but that code must afect only one function.... how can i do that?

0 Answers  

---

What is bulk load in oracle?

0 Answers  

---

15. Display the item_cost and then truncate it to the nearest hundred, ten, unit, tenth and hundredth.

0 Answers   Wipro,

---

What does COMMIT do ?

4 Answers  

---

Differnce between view and index

3 Answers  

---