Re: PostGreSQL Date Query?

Maybe you have a wrong datestyle format.

Try a query with '01/01/2005' and '01/28/2005' range, in month-day-year
format.

Diego.


El mar, 08-03-2005 a las 23:51 +0200, Lennie De Villiers escribió:
> 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.
>
> Anyone can help me.
>
>
>
> Using Java 2 SE 1.4.2, PostGreSQL 8.0
>
>
> Kind Regards,
>
>
>
> Lennie De Villiers
>
>
>
>
>