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 Index and different types of Indexes?

7 Answers  

---

What is a table index in oracle?

0 Answers  

---

what is trigger?

6 Answers   Oracle,

---

What is a recycle bin in oracle?

1 Answers  

---

What are a cluster and non-cluster index?

0 Answers  

---

---

What is the difference between "as" and "is" in an oracle stored procedure?

0 Answers  

---

i have a table with the columns below as Emp_ID Address_ID Address_Line City Country -------- --------- ----------- ------ --------- Q: Display the Emp_ID's those having more than one Address_ID

7 Answers   IBM,

---

Whether any commands are used for months calculation? If so, what are they?

0 Answers  

---

Give syntax for SQL and ORACLE joins.

0 Answers   TCS,

---

select trunc(round(156.00,-1),-1) from dual;

2 Answers  

---

What is blob data type in oracle?

0 Answers  

---

What is the usage of synonyms?

0 Answers  

---