No, you can store as (HH24:MI) at form level, also make format DateTime

Is it possible to enter only time value into a column of a
table in sql?

Question Posted / zaheer

2 Answers
5053 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

Please Help Members By Posting Answers For Below Questions

What is query image?

977

What is an oracle table?

978

How to change program global area (pga) in oracle?

1079

Is there any function in oracle similar like group_concat of mysql?

1043

How to invoke the original export import utilities?

1047

What is a system tablespace and when it is created?

964

What happens if the update subquery returns multiple rows?

1106

What is translate in oracle?

1087

How to bring a tablespace online?

1067

How to get a list of all user accounts in the database?

1083

What is merge in oracle?

1046

What is bind variable in oracle 11g?

1032

Explain the difference between replace() and translate() functions in oracle?

1026

In oracle there is column command, how will you explain that?

1034

What is a trigger oracle?

1079