Interested to Buy Any Domain ? << Click Here >> for more details...
how to store only time in a data base table
- 2 Answers
- 5139 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 |
How to export several tables together?
Please explain joins in oracle?
IS it possible to built the oracle database without setting the kernal parameters?
waht is the difference between primary key and super key?
Explain what are clusters?
Explain constraining triggers.
What is Read-Only Transaction ?
What is a Sequence ?
Explain what are the different type of segments?
What is the dynamic sql in oracle?
What is a Database instance ? Explain?
Why packages are used in oracle?
Oracle General 
