Re: Bug with timestamp !!!

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Eric G(dot) Miller" <egm2(at)jps(dot)net>
Cc: PostgreSQL General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Bug with timestamp !!!
Date: 2001-05-14 01:31:40
Message-ID: 4662.989803900@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-bugs pgsql-general

"Eric G. Miller" <egm2(at)jps(dot)net> writes:
> After doing that, the results become consistent regardless of the order
> of the calls. You can't use "memset(theTime, 0, sizeof(struct tm))"
> because when tm_isdst = 0 it say daylight savings time is false (which
> you don't know yet from a string like '2001-04-01 02:30:30').

But we don't do that --- we set tm_isdst = -1 so as to ask mktime's
opinion whether the time is DST or not. That is the case that seems
to have some history-dependent behavior ...

regards, tom lane

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Jesus Sandoval 2001-05-14 06:57:25 Re: CREATE TABLE (allow/deny)
Previous Message Eric G. Miller 2001-05-14 00:36:29 Re: Bug with timestamp !!!

Browse pgsql-bugs by date

  From Date Subject
Next Message Todd R. Eigenschink 2001-05-14 02:32:49 Re: REQ: build src/backend/postgres w/o -lncurses or -lreadline
Previous Message Eric G. Miller 2001-05-14 00:36:29 Re: Bug with timestamp !!!

Browse pgsql-general by date

  From Date Subject
Next Message hiroko 2001-05-14 01:41:34 Roooooooooooooll back!
Previous Message Eric G. Miller 2001-05-14 00:36:29 Re: Bug with timestamp !!!