Garry Saddington schrieb:
I have 'datestyle ISO,DMY' set in postgresql.conf but the date output is still rendered in the format (y,m,d) . How can I change this behaviour? regardsgarry
See my answer on the Zope list. The style however influences the way dates are parsed by default, so you need to take care when you feed dates from your application to database. You should also use to_date() to make it explicit. Regards Tino