Check the datestyle settings in the manual. Also look at to_char, with that
you can format the data any way you like,
Maybe: set DateStyle = sql,european;
On Thu, Dec 11, 2003 at 03:35:39PM -0200, Netto wrote:
> 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
--
Martijn van Oosterhout <kleptog@svana.org> http://svana.org/kleptog/
> (... have gone from d-i being barely usable even by its developers
> anywhere, to being about 20% done. Sweet. And the last 80% usually takes
> 20% of the time, too, right?) -- Anthony Towns, debian-devel-announce
