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
What is a cursor and what are the steps need to be taken?
How to write a query with an inner join in oracle?
ur a sql devoloper...what is the process in ur company for finding the database BUGS .. seperate DB testers are there? or devr.s are manage? if DB TESTERS in there what is the process
How do I spool in oracle?
Is it possible to set second Primary Key Constraint in a table in Oracle Database ?
What is ceil and floor in oracle?
Does facebook use oracle?
What is the use of file param in imp command?
How can we create the complete backup of data in the oracle.
What is an oracle?
What is the difference between count (*), count (expression), count (distinct expression)?
Can we connect to ORACLE db using Windows Authentication?
Explain what are the different type of segments?
What is oracle and what are its different editions?
Is postgres faster than oracle?