Thread: 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