Re: time zone on timestamp fields

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Arno A(dot) Karner" <karner(at)tnss(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: time zone on timestamp fields
Date: 2003-08-01 00:29:13
Message-ID: 2116.1059697753@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

"Arno A. Karner" <karner(at)tnss(dot)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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2003-08-01 00:38:02 Re: Stuck Spinlock Error Message
Previous Message Romildo Wildgrube 2003-08-01 00:18:47 Re: a question