PostGreSQL Date Query? - Mailing list pgsql-jdbc

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