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

From Prasanth
Subject Re: PostGreSQL Date Query?
Date
Msg-id LGEKIACNKCMPMALCJMLOMENNEBAA.dbadmin@nqadmin.com
Whole thread Raw
In response to Re: PostGreSQL Date Query?  (Scott Marlowe <smarlowe@g2switchworks.com>)
List pgsql-jdbc
>Sounds like your month and day are not where you think they are.

In which case you will get an error message saying that "date/time field
value out of range."

-Prasanth.

-----Original Message-----
From: pgsql-jdbc-owner@postgresql.org
[mailto:pgsql-jdbc-owner@postgresql.org]On Behalf Of Scott Marlowe
Sent: Thursday, March 10, 2005 2:39 PM
To: Lennie De Villiers
Cc: pgsql-jdbc@postgresql.org
Subject: Re: [JDBC] PostGreSQL Date Query?


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-DA
TETIME-INPUT

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend





pgsql-jdbc by date:

Previous
From: Dave Cramer
Date:
Subject: Re: PostGreSQL Date Query?
Next
From: Scott Marlowe
Date:
Subject: Re: PostGreSQL Date Query?