Interested to Buy Any Domain ? << Click Here >> for more details...
Is it possible to enter only time value into a column of a
table in sql?
- 2 Answers
- 5061 Views
- I also Faced
- E-Mail Answers
Answer Posted / zaheer
No,
you can store as (HH24:MI) at form level, also make format
DateTime.
Query by - to_date(HH24:MI)
Also you can use Timestamp - I tied it in Oracle 10g. It
will store date and time
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are privileges and grants?
Explain an index segment?
What are the different types of database objects?
How to store pictures on to the database?
Explain enable novalidate constraint.
What is proxy method?
What is system global area (sga) in oracle?
Explain oracle left join with an example?
Explain the use of owner option in exp command.
What is Undo Management Advisor in Oracle?
Explain the difference between a procedure and a function? What do you understand by those terms?
How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?
How do you find out from the RMAN catalog if a particular archive log has been backed-up?
 How to use an oracle sequence generator in a mapping?
How to create a single index for multiple columns?
