Re: Bug in date_part() - Mailing list pgsql-bugs

From Thomas Lockhart
Subject Re: Bug in date_part()
Date
Msg-id 3A65C497.A366577@alumni.caltech.edu
Whole thread Raw
In response to Bug in date_part()  (phil@Stimpy.netroedge.com)
Responses Re: Re: Bug in date_part()
List pgsql-bugs
> 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
current sources (dow for April 1 comes up as zero, as you would expect).
What machine are you running on, and how did you build?

                     - Thomas

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: Bug in date_part()
Next
From: Tom Lane
Date:
Subject: Re: heap_sysoffset is not found