problem inserting DATE type.
Hello all..
I have Table like this..
SQL> desc mydate;
Name Null? Type
----------------------------------------- -------- ---------------
DATE1 DATE
When i try to insert date using INSERT statement, i am getting an error. I have the date in 7/1/1998 format.
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
SQL> insert into mydate values to_date('7/1/1998', 'mm/dd/yyyy');
insert into mydate values to_date('7/1/1998', 'mm/dd/yyyy')
*
ERROR at line 1:
ORA-03001: unimplemented feature
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
How do i insert this date into my database ?...
thanks
Ron