how to store only time in a data base table
- 2 Answers
- 4112 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 is a proxy class?
what are the default admin accounts in Oracle 10g ?
What are the factors causing the reparsing of SQL statements in SGA?
How to add a new column to an existing table with a default value?
Give the sequence in which triggers fired during insert operations, when the following 3 triggers are defined at the same block level ?
What is the oracle implicit cursor?
How to speed up webrick?
how to delete all duplicate records from a table using subquery?
What is columnar storage what is the advantage?
candidate key is subset of super key but not vice-verse explain
i can create a view with two columns from emp table,, later i need to add one more emp column to existing view.. what is query similarly add one more column to existing primary key constraint.. please give me the solutions
What privilege is needed for a user to create tables in oracle?
Oracle General 
