Re: time zone on timestamp fields

От:

Tom Lane <tgl@sss.pgh.pa.us>

Дата:

31 июля 2003 г. в 21:29:14

"Arno A. Karner"  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

time zone on timestamp fields

От:

"Arno A. Karner" <karner@tnss.com>

Дата:

31 июля 2003 г. в 20:58:14

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