Is it possible to enter only time value into a column of a
table in sql?
Answers were Sorted based on User's Feedback
Answer / nannesaheb c
There is no such data type is existed in Oracle to store the time in a column directly.
However we can insert the time value in a column using the sql functions as below.
SELECT substr(to_char(sysdate,'DD-MON-YYYY HH:MM:SS'),12,20) FROM dual;
create table time1
(
today_time varchar2(10)
);
insert into time1 values(substr(to_char(sysdate,'DD-MON-YYYY HH:MM:SS'),12,20));
Regards,
Nanne
Is This Answer Correct ? | 0 Yes | 0 No |
Describe the types of sub query?
What are the differences between char and nchar in oracle?
how to get count of tables in particular database in Oracle?
Query to get max and second max in oracle in one query ?
34 Answers CTS, Keane India Ltd, TCS, Wipro,
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
i must get table name, constraint type, constrain name with using concads "||" and it must be in string type, then with join processes i need code please help immidiately
How to invoke the original export import utilities?
What is an anonymous block?
how to do daily transactions with out sql* loader control file regesterd in apps?
What happens to the indexes if a table is recovered?
How to turn on or off recycle bin for the session?
How to select some rows from a table in oracle?