Re: Bug #630: date/time storage problem: timestamp parsed

From: Andreas Schwab <schwab(at)suse(dot)de>
To: Thomas Lockhart <lockhart(at)fourpalms(dot)org>
Cc: Reinhard Max <max(at)suse(dot)de>, Sean Chittenden <sean(at)chittenden(dot)org>, pgsql-bugs(at)postgresql(dot)org, Andreas Jaeger <aj(at)suse(dot)de>
Subject: Re: Bug #630: date/time storage problem: timestamp parsed
Date: 2002-04-11 16:19:24
Message-ID: je4rii1a43.fsf@sykes.suse.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Thomas Lockhart <lockhart(at)fourpalms(dot)org> writes:

|> > This is the bug report against glibc that prompted the change:
|> > http://bugs.gnu.org/cgi-bin/gnatsweb.pl?cmd=view%20audit-trail&database=default&pr=2738
|> > |> Ah, but this might explain why I've always seen on my Linux box a 1
|> > |> second offset returned from mktime() for dates before 1970. Everything
|> > |> is shifted to allow -1 to be a special value I'll bet...
|> > This is a joke, isn't it?
|>
|> Yes and no; the behavior is in localtime(), not mktime() -- sorry for my
|> faulty memory. The case I am handling is in recovering local time given
|> a time_t (in UTC of course). I have independently derived a broken-down
|> time structure, so have both the original structure and the results of
|> localtime() available in my code. Here is the relevant comment snippet:

Do you have a testcase?

Andreas.

--
Andreas Schwab, SuSE Labs, schwab(at)suse(dot)de
SuSE GmbH, Deutschherrnstr. 15-19, D-90429 Nürnberg
Key fingerprint = 58CA 54C7 6D53 942B 1756 01D3 44D5 214B 8276 4ED5
"And now for something completely different."

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Donald A Pellegrino 2002-04-11 16:23:18 Re: Bug #631: pg_dumpall does not accept -F or -f
Previous Message Thomas Lockhart 2002-04-11 15:59:58 Re: Bug #630: date/time storage problem: timestamp parsed