Re: PostGreSQL Date Query?

You'd think that as the guy who'd pissed and moaned until the old
behaviour was changed I would have thought of that. but no...

Too much going on today. I bet it's a text field.

On Thu, 2005-03-10 at 14:45, Dave Cramer wrote:
> That's what I thought too, but pg should give him an error if he is
> asking for the 28th month.
>
> Dave
>
> Scott Marlowe wrote:
>
> >On Tue, 2005-03-08 at 15:51, Lennie De Villiers wrote:
> >
> >
> >>Hi,
> >>
> >>
> >>I'm using Java together with PostGreSQL database.
> >>
> >>
> >>
> >>I'm having a problem with a date query, when I write:
> >>
> >>
> >>
> >>select sRescheduleDate, * from tbl_leads
> >>
> >>where sRescheduleDate >= '01/01/2005' AND sRescheduleDate <=
> >>'28/01/2005'
> >>
> >>and bRescheduleCall = true
> >>
> >>
> >>
> >>the query also return the values for "01/04/2005" where it should only
> >>return those between that date range.
> >>
> >>
> >
> >Sounds like your month and day are not where you think they are.
> >
> >http://www.postgresql.org/docs/7.4/static/datatype-datetime.html#DATATYPE-DATETIME-INPUT
> >
> >---------------------------(end of broadcast)---------------------------
> >TIP 8: explain analyze is your friend
> >
> >
> >
> >