Обсуждение: Postgres DateStyle

Hi:

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

What am I doing wrong?

Saludos,

Roberto Andrade Fonseca
randrade@abl.com.mx

(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

On Fri, 14 Jul 2000, Thomas Lockhart wrote:

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

Thanks Thomas:

I was doing something stupid: my data type was date, not timestamp. That explained
my error.

Saludos,

Roberto Andrade Fonseca
randrade@abl.com.mx