Interested to Buy Any Domain ? << Click Here >> for more details...
how to store only time in a data base table
- 2 Answers
- 5133 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 |
Why is oracle used?
How to join two tables in a single query using oracle?
What is the oracle implicit cursor?
What is set verify off in oracle?
How to create a new table in oracle?
What is the effect of setting the value of OPTIMIZER_MODE to 'RULE' ?
What is Read-Only Transaction ?
How to delete a column in an existing table?
What is memory advisor in Oracle?
How do I manually uninstall oracle client?
Tab A A B ------ 1 A 2 B 3 C Tab B A B ----- 4 D 5 E 6 F Generate the value into B table from A table. Only table A has the value. Write the SQL query to get B table value.
what are corelated subqueries
Oracle General 
