Re: Bug in date_part()

From: Thomas Lockhart <lockhart(at)alumni(dot)caltech(dot)edu>
To: phil(at)Stimpy(dot)netroedge(dot)com
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: Bug in date_part()
Date: 2001-01-17 16:13:11
Message-ID: 3A65C497.A366577@alumni.caltech.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Alfonso Peniche 2001-01-17 16:28:12 Re: Problem
Previous Message Alexander Klimov 2001-01-17 14:28:29 heap_sysoffset is not found