Re: Postgres DateStyle

(My mailer was fouled up; I had sent this a few days ago...)

> > The documentation of Postgresql 7.0.2 says that the statement:
> > SET DATESTYLE TO 'Postgres';
> > would led to an output of the form:
> > Wed Dec 17 07:37:16 1997 PST
> > but I can't reproduce this behavior!!!
>
> lockhart=# select timestamp 'now';
> ?column?
> ---------------------------
> 2000-07-11 15:48:24.00+00
> (1 row)
>
> lockhart=# set datestyle to 'Postgres';
> SET VARIABLE
> lockhart=# select timestamp 'now';
> ?column?
> ---------------------------------
> Tue Jul 11 15:48:35.00 2000 UTC
> (1 row)
>
> Please show a transcript of your session if you need some more
> suggestions.
>
> - Thomas