Re: BETWEEN not matching on timestamp value - Mailing list pgsql-general

From Tom Lane
Subject Re: BETWEEN not matching on timestamp value
Date
Msg-id 23081.1246385260@sss.pgh.pa.us
Whole thread Raw
In response to Re: BETWEEN not matching on timestamp value  ("James B. Byrne" <byrnejb@harte-lyne.ca>)
List pgsql-general
"James B. Byrne" <byrnejb@harte-lyne.ca> writes:
> The column is a timestamp value.  I expected any time on any given
> date to fall between the start and end of that day so the
> hh:mm:ss:hh portion does not leap out at me as something that should
> cause a problem.  Should  it?

It's the eight-digit year field that it's unhappy with ...

            regards, tom lane

pgsql-general by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: BETWEEN not matching on timestamp value
Next
From: "James B. Byrne"
Date:
Subject: Re: BETWEEN not matching on timestamp value]