PostGreSQL Date Query?

From: "Lennie De Villiers" <lenniedg(at)lando(dot)co(dot)za>
To: <pgsql-jdbc(at)postgresql(dot)org>
Subject: PostGreSQL Date Query?
Date: 2005-03-08 21:51:21
Message-ID: !~!UENERkVCMDkAAQACAAAAAAAAAAAAAAAAABgAAAAAAAAA7eJwAxNWM0C1nHgqelJlQsKAAAAQAAAA/2qJuDRRtES178L9Pf40owEAAAAA@lando.co.za
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Antony Paul 2005-03-09 03:58:40 Re: FW: PreparedStatement#setString on non-string parameters
Previous Message Oliver Jowett 2005-03-08 21:47:34 Re: FW: PreparedStatement#setString on non-string parameters