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

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 (view raw or flat)
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: nabstime.c.patch
Description: text/plain (2.9 KB)
Attachment: dt.c.patch
Description: text/plain (5.8 KB)
Attachment: datetime.c.patch
Description: text/plain (3.8 KB)

Responses

pgsql-hackers by date

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

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