DATE PROBLEM!

From: Ray <raymondsee_at_home.com>
Date: 2000/05/16
Message-ID: <RY4U4.70100$R4.384649_at_news1.rdc1.nj.home.com>#1/1


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 Tue May 16 2000 - 00:00:00 CEST

Original text of this message