Обсуждение: time zone on timestamp fields

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?
is this going to be the default going forward from 7.3.2, is this just
somthing temporary, should I just pick another style (grr iso pipes thru
sort so nice). Comments sugjestions?

    Thanks in advance
        Arno

"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