PostGreSQL Date Query?
| От | Lennie De Villiers |
|---|---|
| Тема | PostGreSQL Date Query? |
| Дата | |
| Msg-id | !~!UENERkVCMDkAAQACAAAAAAAAAAAAAAAAABgAAAAAAAAA7eJwAxNWM0C1nHgqelJlQsKAAAAQAAAA/2qJuDRRtES178L9Pf40owEAAAAA@lando.co.za обсуждение |
| Ответы |
Re: PostGreSQL Date Query?
Re: PostGreSQL Date Query? Re: PostGreSQL Date Query? |
| Список | pgsql-jdbc |
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
В списке pgsql-jdbc по дате отправления: