Is it possible to enter only time value into a column of a
table in sql?
- 2 Answers
- 4581 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 the advantages of oracle 12c?
What is sharded cluster?
What is an index associated with a constraint?
What is a read only transaction in oracle?
Explain what are synonyms used for?
What is the difference between a hot backup and a cold backup in oracle?
How to check database size in Oracle?
What are the roles of dba?
How to select some columns from a table in oracle?
Explain a private synonyms?
Explain the use of control file?
Can we store pictures in the database and if so, how it can be done?
How to find the duplicate rows count from employees table in oracle?
How to recover a dropped table in oracle?
How to retrieve values from data fields in record variables?
