Ah, I think I understand the trouble now. It's good it's fixed for
the next release. And, as predicted, I'm running in a DST zone
(/etc/localtime -> ../usr/share/zoneinfo/US/Pacific)
Thanks for the quick diagnosis!
Phil
On Wed, Jan 17, 2001 at 09:07:34PM -0500, Tom Lane wrote:
> Thomas Lock
> I get the right answer from current sources, and the wrong one on 7.0.2.
> It's ye olde date-to-timestamp-off-an-hour-at-DST-boundary problem.
> Are you not running in a USA timezone?
Oh right. I'm usually in GMT, which is a bad place to test time zone
behavior, eh?
- Tho
Thomas Lockhart <[EMAIL PROTECTED]> writes:
>> Query to reproduce the bug (7.0.3):
>> edge=# select date_part('dow','4/1/2001'::date)::int4;
>> --
>> 6
> I'm not seeing this on my 7.0.2 RPM installation, or on my from-cvs
> current sources (dow for April 1 comes up as zero, as you would e
> Query to reproduce the bug (7.0.3):
> edge=# select date_part('dow','4/1/2001'::date)::int4;
> --
> 6
> Clearly, the first of April ... is not on Saturday ... (and my app) was displaying
>April
> 2001 wrong.
I'm not seeing this on my 7.0.2 RPM installation, or on my from-cvs
cu
