Problems with the Date..

Dear Reader,

I've got a date field in my DB (PostgreSQL database). When I insert the following value with the program 'psql' it works fine..

INSERT INTO kandidaat (id, wens_datum) VALUES (nextval('kandidaat_id_seq), '11-10-1984');

but when I trie to insert it from a webpage I get an error (see below) what do I wrong?

Warning: PostgreSQL query failed: ERROR: Bad date external representation

I also treid the following query

INSERT INTO kandidaat (id, wens_datum) VALUES (nextval('kandidaat_id_seq), '1984-11-10');

When I do this in 'psql' I get inserted in the DB the value '1984-11-10' just as I insert '11-10-1984'.. So does anybody know why this doesn't work?

Greetings,

Kasper Schoonman (16yr)
The Netherlands

Sorry Guys,

I already fixed the problem!

Gr.

Kasper

Don't suppose you could share what was wrong with the pg insert? I am having the same problem.

Thanks,