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 execution control statements?

0 Answers  

---

What is the effect of setting the value "all_rows" for optimizer_goal parameter of the alter session command? What are the factors that affect optimizer in choosing an optimization approach?

0 Answers  

---

How to create a table index in oracle?

0 Answers  

---

5. Display full details from the ORDER_LINE table where the item number is (first condition) between 1 and 200 (no > or < operators) OR the item number is greater than 1000 AND (second condition) the item cost is not in the list 1000, 2000, 3000 OR the order number is not equal to 1000.

3 Answers   Wipro,

---

How many categories of data types?

0 Answers  

---

IS it possible to built the oracle database without setting the kernal parameters?

0 Answers   EDS,

---

What is Data Dictionary Cache in Oracle?

0 Answers   MCN Solutions,

---

Write a syntax for update query in oracle?

0 Answers  

---

Explain integrity constraint?

0 Answers  

---

Differentiate between TRUNCATE and DELETE?

2 Answers  

---

can u call user defined functions in select statements

2 Answers  

---

Explain mutating triggers.

0 Answers  

---