how to store only time in a data base table
- 2 Answers
- 4116 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 are the different types of cursors? explain?
how to find the second highest salary in a given table????
select to_char('10','10') from dual This gives me an error oRA-1481 INVALID NUMBER FORMAT MODEL why? pls help
What is the database name in oracle?
What is snapshot is too old? Give and example for better understand.
query to find the maximum no persons with same age(age colomn) from emp table
What is a trace file and how is it created in oracle?
select statement does not retrieve any records. what exception is raised?
what is load balancing and what u have used to do this?(sql loader)
Explain oracle’s system global area (sga).
why can't we assign not null constraint as table level constraint
What are the predefined tablespaces in a database?
Oracle General 
