Interested to Buy Any Domain ? << Click Here >> for more details...
how to store only time in a data base table
- 2 Answers
- 5047 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 do you mean by a tablespace?
candidate key is subset of super key but not vice-verse explain
How to sort output in descending order in oracle?
what is host string in sql plus? how does it related to database?
I want a table like, no name address addr1 addr2 So i want columns like addr1,addr2 under address column. Can one please answer me. Advance Thanks.
What is the implicit cursor in oracle?
How to export data with a field delimiter?
waht is the difference between primary key and super key?
What is a cluster Key ?
How to define an oracle cursor variable?
how the indexes are stored in the Oracle Database?
What is a Tablespace?
Oracle General 
