=?ISO-8859-1?Q?Karsten_D=FCsterloh?= writes:
> Under Pg 8.3, we used the timestamp
> 0001-01-01 00:00:00+01
> as an easy-to-remember marker for 'dunno, but predates any usual
> business dates' for fields of type timestamp with time zone.
Have you considered using '-infinity'?
> With Pg 9.1, th
Karsten Düsterloh wrote
> hubert depesz lubaczewski wrote:
> > ZoneEurope/Berlin 0:53:28 - LMT 1893 Apr
> The question remains, though, where this special value comes from ?
That was probably the local time at Berlin, with 12:00 the moment when the
sun was highest. With the advent
hubert depesz lubaczewski wrote:
>> Under Pg 8.3, we used the timestamp
>> 0001-01-01 00:00:00+01
>> as an easy-to-remember marker for 'dunno, but predates any usual
>> business dates' for fields of type timestamp with time zone.
>
> Why didn't you use "-infinity" for this?
Back when that value
On pią, maj 10, 2013 at 10:34:02 +0200, Karsten Düsterloh wrote:
> Under Pg 8.3, we used the timestamp
> 0001-01-01 00:00:00+01
> as an easy-to-remember marker for 'dunno, but predates any usual
> business dates' for fields of type timestamp with time zone.
Why didn't you use "-infinity" for thi
Hi!
Recently, we switched from Pg 8.3 to Pg 9.1, using Pg9's pg_upgrade to
migrate our cluster. The cluster itself is running on a Debian 6 machine
with timezone Europe/Berlin, which means UTC+02 currently.
Under Pg 8.3, we used the timestamp
0001-01-01 00:00:00+01
as an easy-to-remember marker