Hi Ashish,

In your example, I believe that the "nls_date_format" parameter governs how
the date string is converted into a date. Most likely, this value is not
'DD-MON-YYYY' for JAD.

~Dan.

-----Original Message-----
From: Ashish Shah [mailto:[Email Address Removed] Thursday, May 31, 2001 12:51 PM
To: LazyDBA.com Discussion
Subject: Re: Insert Error


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 documentation is here:
http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] 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
Oracle LazyDBA home page