what is datatype of your date columns. I tried
following and it worked fine for me..

SQLWKS> create table temp (col1 date);
Statement processed.
SQLWKS> insert into temp values('15-may-01');
1 row processed.

Ashish
--- "Dancy, Jerry A (Jerry)** CTR **"
<[Email Address Removed] wrote:
> I issued the following query and I was given the
> following error. I have
> never encountered this error and the error manual is
> not much help. I dont
> know anything about date format pictures. Any
> advice?
>
> Thanks everyone
>
> JAD
>
>
>
> 1 insert into aodbab2k.employee_event
> 2 (EMPL_HR_ID, CHANGE_CD, CHANGE_TYPE,
> EFFECTIVE_DATE,
> 3 SEQUENCE_NUM, ASSORCL_POSTD_DATE)
> 4* values ('ZH81RHX', '1401', 'PAC',
> '15-MAY-2001',9, '31-MAY-2001')
> SHRT-AODBA> /
> insert into aodbab2k.employee_event
> *
> ERROR at line 1:
> ORA-01830: date format picture ends before
> converting entire input string
>
> --------
> Oracle documentation is here:
> http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
> To unsubscribe: send a blank email to
> oracledba-[Email Address Removed] To subscribe: send a blank email to
> oracledba-[Email Address Removed] Visit the list archive:
> http://www.LAZYDBA.com/odbareadmail.pl
> Tell yer mates about http://www.farAwayJobs.com
> By using this list you agree to these
> terms:http://www.lazydba.com/legal.html
>


__________________________________________________
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail - only $35
a year! http://personal.mail.yahoo.com/
Oracle LazyDBA home page