Date/time fixes for HAVE_TM_ZONE platforms

From: "Thomas G(dot) Lockhart" <lockhart(at)alumni(dot)caltech(dot)edu>
To: Oleg Broytmann <phd(at)sun(dot)med(dot)ru>, Postgres Patches List <patches(at)postgresql(dot)org>
Cc: Postgres Hackers List <hackers(at)postgresql(dot)org>
Subject: Date/time fixes for HAVE_TM_ZONE platforms
Date: 1998-12-31 16:58:23
Message-ID: 368BAD2F.BFA181B3@alumni.caltech.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Here are some patches which fix the recently reported date/time problems
on linux/glibc2 machines. Note that these will also fix any machine
which "tests positive" for HAVE_TM_ZONE, which might include SunOS and
xBSD machines.

The symptom can be demonstrated by the following query:

select datetime('2000-01-01'::date);

which, if there is a problem, will return a time away from midnight.
Note that your time zone must be set to something other than GMT for
this test to be meaningful.

Thanks Oleg for being persistant!

- Tom

Attachment Content-Type Size
datetime.c.patch text/plain 3.8 KB
dt.c.patch text/plain 5.8 KB
nabstime.c.patch text/plain 2.9 KB

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 1998-12-31 20:18:08 Re: [HACKERS] psql: stdout or stderr?
Previous Message Tom Lane 1998-12-31 16:20:13 Re: [HACKERS] psql: stdout or stderr?