| 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 |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| 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
>
>
>
>
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dave Cramer | 2005-03-10 20:45:22 | Re: PostGreSQL Date Query? |
| Previous Message | Dave Cramer | 2005-03-10 20:43:44 | Re: PostGreSQL Date Query? |