Re: DATE type
peter zorbas wrote:
> insert into table (col1, col2, date) values ('123', '1234', 2005-08-08);
You have to quote your date. And if col1 and col2 are numeric (INT, FLOAT, ...) data types, you don't need to quote them:
INSERT INTO table (col1, col2, date) VALUES (123, 1234, '2005-08-08');
--
felix
Please use
BBCode to format your messages in this forum.
Subject
Written By
Posted
Re: DATE type
August 18, 2005 05:12AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.