Re: Bug in date_part()
Thomas Lockhart <lockhart@alumni.caltech.edu>
From: Thomas Lockhart <lockhart@alumni.caltech.edu>
To: phil@Stimpy.netroedge.com
Cc: pgsql-bugs@postgresql.org
Date: 2001-01-17T16:13:11Z
Lists: 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