Re: Postgres DateStyle - Mailing list pgsql-general

From Thomas Lockhart
Subject Re: Postgres DateStyle
Date
Msg-id 396F202A.99F766CD@alumni.caltech.edu
Whole thread Raw
In response to Postgres DateStyle  ("Ing. Roberto Andrade Fonseca" <randrade@abl.com.mx>)
Responses Re: Postgres DateStyle  ("Ing. Roberto Andrade Fonseca" <randrade@abl.com.mx>)
List pgsql-general
(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

pgsql-general by date:

Previous
From: ernie cline
Date:
Subject: Re: performance question
Next
From: Thomas Lockhart
Date:
Subject: Re: performance question