From: | "Ing(dot) Roberto Andrade Fonseca" <randrade(at)abl(dot)com(dot)mx> |
---|---|
To: | Thomas Lockhart <lockhart(at)alumni(dot)caltech(dot)edu> |
Cc: | pgsql-general(at)postgreSQL(dot)org |
Subject: | Re: Postgres DateStyle |
Date: | 2000-07-14 14:52:51 |
Message-ID: | Pine.LNX.4.10.10007140948480.7878-100000@inter.interservice.com.mx |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(at)abl(dot)com(dot)mx
From | Date | Subject | |
---|---|---|---|
Next Message | Sean Alphonse | 2000-07-14 15:04:04 | Postmaster response |
Previous Message | Thomas Lockhart | 2000-07-14 14:25:16 | Re: performance question |