how to store only time in a data base table
- 2 Answers
- 4098 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 |
Explain an index?
How to delete all rows a table in oracle?
How to add a new column to an existing table with a default value?
Hi this srilatha. I comlpeted my Oracle-hrms. can u provide me interview questions on Core hr, payroll,sshr,OLM etc..
if you ctreate table identity
How to create a table index in oracle?
what is foreign key?
Can a formula column referred to columns in higher group ?
How to write a query with an inner join in oracle?
How do I spool in oracle?
Explain the use of ignore option in imp command.
What are advantages fo Stored Procedures?
Oracle General 
