Answer Posted / 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

How to start your 10g xe server from command line?

998

---

What is oracle analytical function?

1027

---

Why cursor variables are easier to use than cursors?

1019

---

Is there a function to split a string in plsql?

980

---

What are the differences between lov and list item?

987

---

How to specify default values in insert statement using oracle?

1033

---

What are advantages of dateset in datastage?

2197

---

How do I find my oracle client driver version?

969

---

What are the types of trigger in oracle?

911

---

What is a package in oracle?

1023

---

How do you get nicely formatted results from an oracle procedure that returns a reference cursor?

1005

---

What is connection pooling in oracle?

910

---

What happens if the imported table already exists?

970

---

Explain the difference between replace() and translate() functions in oracle?

973

---

What do you mean by a database transaction & what all tcl statements are available in oracle?

931

---