The way PostgreSQL deals with the date format is confusing me... I need PostgreSQL to return dates from selects at this format: "dd/mm/yyyy", but it insists in returning it as "yyyy-mm-dd". I say "insists" cause I had already set datestyle to "European" (in postgresql.conf) which represents the format I want... I checked it executing: "SHOW DATESTYLE" and I got: DateStyle ----------- ISO with European conventions
When inserting dates, PostgreSQL understands very well my date format like "dd/mm/yyyy", but it is also important to get the date like that. I think it's possible, but I had tried all the tricks I knew or I could retrieve from manual... Any ideas? Thank you all. Netto ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
