how to store only time in a data base table
- 2 Answers
- 4500 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / sudipta santra
No problem, There are 2 ways for doing this:
1. If the field of the table is timezone then you can set
data or insert data of timezone i.e the timezone is upto
milliseconds.
eg. insert into timetab(time_col) values(select
sysdbtimezone from dual);
2. If the field is varchar2 then you can set the value or
insert the time stamp like that:
insert into timetab(time_col)
values(substr(to_char(sysdate,'DD-MON-RRRR'),13);
| Is This Answer Correct ? | 2 Yes | 1 No |
Answer / ns
select to_char(systimestamp,'HH24:MM:SS') from dual;
| Is This Answer Correct ? | 1 Yes | 0 No |
What is a Synonym ?
How to use like conditions in oracle?
what is the exact definition for pointer?
25. Display the client number and the value of the highest value order placed by that client.
what is difference between foreign key and reference key
what is the difference between primary key & foreign key?
57 Answers CTS, Infosys, La Multi, Sparsh, Wipro,
How to define a procedure inside another procedure?
How do we get field details of a table?
Can sub procedure/function be called recursively?
What is SQL access advisor in Oracle?
How to use attributes of the implicit cursor in oracle?
How to login to the server without an instance?
Oracle General 
