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