Interested to Buy Any Domain ? << Click Here >> for more details...
how to store only time in a data base table
- 2 Answers
- 5006 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 |
Draw E-R diagram for many to many relationship ?
How to establish administrator authentication to the server?
How can I create database in oracle?
Why do we use coalesce function in oracle?
What is Database Link ?
How you open and close a cursor variable.Why it is required?
How to install oracle database 10g xe?
State any two functions of oracle?
sql query to get zero records from a table
what is the difference between rollback & commit? can a foreign key has null value?
Query to retrieve record for a many to many relationship ?
How to create a temporary table in oracle?
Oracle General 
