how to store only time in a data base table
- 2 Answers
- 4114 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 advantages of oracle 12c?
Can a field be used in a report without it appearing in any data group ?
What is java oracle used for?
What is the difference between SQL, DDL, and DML?
7 Answers BeBo Technologies, Wipro,
How to use attributes of the implicit cursor in oracle?
Can objects of the same schema reside in different tablespace?
Explain 1st, 2nd, 3rd normalization form of data base
Can a Tablespace hold objects from different Schemes ?
Difference between join and a subquery?
8 Answers Base Automation, NMDC,
What are internal user account in oracle?
Explain the types of exception?
State and explain about oracle instance?
Oracle General 
