Re: DATE PROBLEM!

The problem is the single quote in "man's" : you need to use two single quotes...

Ray <raymondsee_at_home.com> wrote in message news:RY4U4.70100$R4.384649_at_news1.rdc1.nj.home.com...
> Hey all,
>
> Can anyone tell me what's the problem in this insert statement?
>
> Insert into book values ('0-044-45630-1', 'Empire boys : Adventures in a
> man's world', 'Joseph Bristol', 'Fiction', '07/99', '29.99', '35.99',
 '60',
> 'McGraw-Hill Companies, Inc');
>
> I got some error message saying
> ERROR:
> ORA-01756: quoted string not properly terminated
>
> I suspect i didn't put the date correctly, any suggestions? I just need
 the
> month and year....July 1999!
>
> Thanks
> RAY
>
>
>
>
>
>
>
>
Received on Mon May 15 2000 - 00:00:00 CEST