Skip site navigation (1) Skip section navigation (2)

Re: PostGreSQL Date Query?

From: Diego Gil <diego(at)adminsa(dot)com>
To: Lennie De Villiers <lenniedg(at)lando(dot)co(dot)za>
Cc: JDBC Postgresql <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: PostGreSQL Date Query?
Date: 2005-03-10 20:44:54
Message-ID: 1110487494.5163.10.camel@roadwarrior.adminsa.com (view raw or flat)
Thread:
Lists: pgsql-jdbc
Maybe you have a wrong datestyle format.

Try a query with '01/01/2005' and '01/28/2005' range, in month-day-year
format.

Diego.


El mar, 08-03-2005 a las 23:51 +0200, Lennie De Villiers escribió:
> 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
> 
> 
> 
> 
> 


In response to

pgsql-jdbc by date

Next:From: Dave CramerDate: 2005-03-10 20:45:22
Subject: Re: PostGreSQL Date Query?
Previous:From: Dave CramerDate: 2005-03-10 20:43:44
Subject: Re: PostGreSQL Date Query?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group