On Wed, 2002-11-06 at 19:25, Jeff Self wrote: > I'm running PostgreSQL 7.2.1 on a Debian Linux server. I have added the > line: PGDATESTYLE=ISO,US to postmaster.conf and restarted PostgreSQL but > any fields with the Date type still show up as '2002-11-06'. I want them > to show up as '11-06-2002'.
ISO format means "yyyy-mm-dd"; you are getting exactly what you asked for. The ",US" part of your spec is controlling how dates are interpreted on input, so it is not useless, but to get what you want you must specify "POSTGRES,US". -- Oliver Elphick [EMAIL PROTECTED] Isle of Wight, UK http://www.lfix.co.uk/oliver GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C ======================================== "Let all that you do be done in love." 1 Corinthians 16:14 ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
