How do I create a datetime within my table as a datatype?
I'm creating a table with a datetime datatyp. I get this error: ORA-00902:invalid datatype.
create table test_reporting.schedule
(report_date datetime,
report_desc varchar2(50));
I keep getting the error above. what am I doing wrong?
create table test_reporting.schedule
(report_date datetime,
report_desc varchar2(50));
I keep getting the error above. what am I doing wrong?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
insert into x
values(99, to_date('1998/05/31:12:00: