Thomas Lockhart <lockhart(at)alumni(dot)caltech(dot)edu> writes:
>> Looks to me like an off-by-one kind of problem in deciding which
>> timezone applies to midnight of a transition day.
> The date->timestamp conversion code gets this right, so you might want
> to look at that.
Au contraire: the cited examples appear to prove that the
date->timestamp conversion code gets this *wrong*. Or did
you miss the point of
regression=# select '2000-04-02'::date::timestamp;
regards, tom lane
In response to
pgsql-bugs by date
|Next:||From: Thomas Lockhart||Date: 2000-09-07 06:07:43|
|Subject: Re: bug in date_part() function in 6.5.2, 7.0.2|
|Previous:||From: Stephan Szabo||Date: 2000-09-06 16:40:56|
|Subject: Re: Possible bug in referential integrity system|