Is it possible to enter only time value into a column of a
table in sql?
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
How to create a server parameter file?
What is Reduced List of Values?
how do u setup a replication site?
What is merge statement used for?
How to synchronize 2 schema's objects?
how can we store any pdf file in oracle
How to do a full database export?
How to export several tables together?
State and explain about oracle instance?
Please explain oracle left join with an example?
How to define an external table with a text file?
How do I limit the number of oracle database connections generated by weblogic server?
What is the difference between a user and a schema in oracle?
21. Using a set operator, display the client number of all clients who have ever placed an order and whose whose name does not contain the string Sm.
What is the data type of dual table?