Postgres Pro
Downloads
Home   >   mailing lists

Re: time zone on timestamp fields - Mailing list pgsql-admin

From Tom Lane
Subject Re: time zone on timestamp fields
Date
Msg-id 2116.1059697753@sss.pgh.pa.us
Whole thread Raw
In response to time zone on timestamp fields  ("Arno A. Karner" <karner@tnss.com>)
List pgsql-admin
Tree view 
"Arno A. Karner" <karner@tnss.com> writes:
> I'm playing with redhat 9.0 which is postgresql 7.3..2
> I set my date style like I have on previous releases to "ISO" the time
> stamps show up in ISO format, but with out time zone info?

"timestamp" now means "timestamp without time zone", per SQL spec.

You want datatype "timestamp with time zone" (or "timestamptz" if you're
lazy).

            regards, tom lane

pgsql-admin by date:

Previous
From: Romildo Wildgrube
Date:
Subject: Re: a question
Next
From: Tom Lane
Date:
Subject: Re: Stuck Spinlock Error Message