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

""scott.marlowe"" <scott(dot)marlowe(at)ihs(dot)com> escreveu na mensagem
news:Pine(dot)LNX(dot)4(dot)33(dot)0312160734110(dot)5679-100000(at)css120(dot)ihs(dot)com(dot)(dot)(dot)

>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.

Hey Scott,... thank you for the tips,... I forgot mentioning the PostgreSQL
version I'm using... its 7.3.2. I read the documentation section you
suggested, and it really solves my problem, since I upgrade postgresql to
7.4.

Netto