DATE syntax in postgresql

[tomycon]

Hello All,

I'm running a postgresql 8 server on a centos 5 system. I've created a table with a couple of fields using the DATE data type. When I try to insert data I get an error "...incorrect syntax for date data type...". The pgsql manuals state a wide variety of date forms are acceptable: Sept 18, 2008, 2008-09-18, 09/18/08 etc.. I've tried all these formats and more and always get an error on the date.

A typical insert statement:
INSERT INTO projects (name, manager, start_date, end_date, status) VALUES ('Mailing', 'ASMITH', '2008-09-09', '2008-09-18', 'Complete');

Any suggestions are apprciated. Thanks!

[DJMaze]

ISO8601 format worked fine in my Postgres.

CREATE TABLE test
(
  t_int integer,
  t_date date
)
WITH (OIDS=FALSE);

INSERT INTO test (t_int, t_date) VALUES (1, '2008-09-09');
INSERT INTO test (t_int, t_date) VALUES (2, '2008-09-18');