Skip site navigation (1) Skip section navigation (2)

Re: timestamps cannot be created without time zones

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, Rainer Mager <rmager(at)vgkk(dot)com>, <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: timestamps cannot be created without time zones
Date: 2001-08-24 22:22:00
Message-ID: Pine.LNX.4.30.0108250020350.677-100000@peter.localdomain (view raw or flat)
Thread:
Lists: pgsql-bugs
Tom Lane writes:

> No, that is *not* what happens.  For dates outside the range known to
> the local platform's timezone database, we effectively assume that all
> times are given in GMT; no timezone corrections are applied on either
> input or output.

Oh, I wasn't sure whether Bruce meant the behaviour in 1850 exactly.

-- 
Peter Eisentraut   peter_e(at)gmx(dot)net   http://funkturm.homeip.net/~peter


In response to

Responses

pgsql-bugs by date

Next:From: Tomasz ZielonkaDate: 2001-08-25 08:18:41
Subject: Re: Re: Strange deadlock problem on simple concurrent SELECT/LOCK TABLE transactions
Previous:From: Bruce MomjianDate: 2001-08-24 21:31:33
Subject: Re: Bug #428: Another security issue with the JDBC driver.

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group