How to fix error on create table

[Dollinn]

[Create table table_name(id int not null, day date, over_in time, over_out time)]

[debasisdas]

There is no time data type in oracle

[amitpatel66]

Has to be DATE datatype instaed of time:

[code=oracle]
SQL> Create table table_name(id int not null, day date, over_in time, over_out time);
Create table table_name(id int not null, day date, over_in time, over_out time)
*
ERROR at line 1:
ORA-00902: invalid datatype


1* Create table table_name(id int not null, day date, over_in date, over_out date)
SQL> /

Table created.

SQL>

[/code]