From: | Martijn van Oosterhout <kleptog(at)svana(dot)org> |
---|---|
To: | Netto <rcnetto(at)yahoo(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Is it not datestyle that determines date format output? |
Date: | 2003-12-15 21:34:47 |
Message-ID: | 20031215213447.GA21071@svana.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(at)svana(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Bruno Wolff III | 2003-12-15 21:37:34 | Re: VACUUM ANALYZE -vs- ANALYZE on an insert-only table. |
Previous Message | Bruce Momjian | 2003-12-15 21:11:14 | Re: versions of PG |