Re: PostGreSQL Date Query?

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