If I do an:
INSERT INTO wdata (date)
VALUES ('13.04.06');
From the Query Tool in PGAdmin it will insert the dd.mm.yy format correctly without problems.
But when I do this in Java I get this error message
SQLException: ERROR: date/time field value out of range: "13.04.06"
SQLState: 22008
VendorError: 0
This is because it reads the date format as mm.dd.yy because when I insert with the value '12.04.06' it works perfect. I've changed the datestyle in my Database to European but it still doesn't work. Do the JDBC driver only insert dates in the US format?
Olav