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
- 5072 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 save query output to a local file?
What is the difference between sharding and partitioning?
How to concatenate two text values in oracle?
Explain a synonym?
What are the various constraints used in oracle?
What operating systems are supported by oracle database 10g xe?
How to divide query output into groups in oracle?
Can group functions be mixed with non-group selection fields?
Does oracle partitioning improve performance?
What are the components of logical database structure in oracle database?
How will you identify oracle database software release?
Name the three major set of files on disk that compose a database in Oracle?
How translate command is different from replace?
Can we write insert statement in function in oracle?
How to store only time; not date and time?
