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
- 4979 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 attributes that are found in a cursor?
Explain view?
How to grant create session privilege to a user in oracle?
Can select statements be used on views in oracle?
Can any one explain me when i execute below query.. select months_between('07-JUL-12','10-FEB-12') from dual; Out put:- 4.90322581 How oracle calculate?
How to insert multiple rows with one insert statement in oracle?
Can we save images in a database and if yes, how?
What is the order of defining local variables and sub procedures/functions?
How do I start tns listener?
How to delete a column in an existing table in oracle?
How do we display rows from the table without duplicates?
How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?
How to connect the oracle server as sysdba?
How do you tell what your machine name is and what is its IP address?
What is SQL Tuning Advisor in Oracle?
