Interested to Buy Any Domain ? << Click Here >> for more details...
how to store only time in a data base table
- 2 Answers
- 5057 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 the Difference between 1) ER MODEL and Relational Model 2) Dense Index and Sparse Index
22. Display the order number, number of lines in the order, total number of items and total value for all orders that have a total value greater than $100
How many types of tables supported by oracle?
Explain the difference between a procedure and a function?
What is the Extension of Oracle Database? As extension of Access Database is .mdb
What is truncate oracle?
What is the difference between count (*), count (expression), count (distinct expression)?
What view(s) do you use to associate a users SQLPLUS session with his o/s process?
What is a table in oracle?
What is an Oracle view?
What is transport network substrate (tns) in oracle?
How to export several tables together?
Oracle General 
