"Andy" <frum@xxxxxxxxx> writes: > I tried to modify it in postgres.conf >>> datestyle = 'European' or > datestyle = 'SQL, DMY' > and I tried to make > alter database test5 SET DateStyle='SQL, DMY'; > .... none of these worked. They work for me. Perhaps you should show us exactly what you did and what happened. regards, tom lane