Re: Is it not datestyle that determines date format output?

On Thu, 11 Dec 2003, 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...

This may be a dup (it arrived in my inbox on 11 Dec 2003), but I'll reply
just in case.

What flavor of Postgresql are you running? I'll assume 7.4.

I'm assuming you've read this section of the docs:

http://www.postgresql.org/docs/current/static/datatype-datetime.html

Have you tried entering:

set DateStyle='SQL, dmy';

ISO style makes it the yyyy-mm-dd format, SQL makes it the other.