On Sun, Apr 24, 2005 at 05:21:41PM +0200, Karsten Hilbert wrote: > > > > As far as I know, it's not possible to get output like the following > > from the same query if the data type is timestamp with time zone: > > > > 2005-04-21 15:00:00-07 > > 2005-04-21 22:00:00+00 > > Doesn't "at time zone" do what you need ? Not as far as I can tell, because if the result is timestamp with time zone then it's rotated to the local time zone for display. If you can post a counterexample then I'd be happy to stand corrected. -- Michael Fuhr http://www.fuhr.org/~mfuhr/ ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org