Re: PostGreSQL Date Query?

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