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
- 5133 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
How to define a data source name (dsn) in odbc manager?
Can you drop an index associated with a unique or primary key constraint?
Explain an exception and its types?
What happens if the update subquery returns multiple rows?
How to update values in a table in oracle?
I have a table called 'test' on source and target with same name, structure and data type but in a different column order. How can you setup replication for this table?
Explain a data segment?
How to invoke the data pump export utility?
Give the advantages and disadvantages of clusters.
How many types of cluster table in Oracle?
How to run create database statement?
Can sub procedure/function be called recursively?
How do we create privileges in oracle?
How to drop an existing view in oracle?
Explain index?
