Re: PostGreSQL Date Query? - Mailing list pgsql-jdbc

From Dave Cramer
Subject Re: PostGreSQL Date Query?
Date
Msg-id 4230B551.4070900@fastcrypt.com
Whole thread Raw
In response to Re: PostGreSQL Date Query?  (Scott Marlowe <smarlowe@g2switchworks.com>)
List pgsql-jdbc
This is why I almost never, no make that never try to set a timestamp or
a date parameter in a java query without using prepared statements
let the driver work out the details...

Dave

Scott Marlowe wrote:

>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
>>>
>>>
>>>
>>>
>>>
>>>
>
>
>
>

--
Dave Cramer
http://www.postgresintl.com
519 939 0336
ICQ#14675561


pgsql-jdbc by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: PostGreSQL Date Query?
Next
From: "Herman Visser"
Date:
Subject: class not found