Home > mailing lists

select date range? - Mailing list pgsql-sql

From	ko
Subject	select date range?
Date	June 17, 2003 02:56:36
Msg-id	02c101c3347c$1279d830$c9641cac@myko Whole thread Raw
Responses	Re: select date range? Re: select date range? Re: select date range?
List	pgsql-sql

Hi,

When I use sql statement to select the date range from $_POST value,It doesn't work.

-------------------------------------------

"select * from mydatabase where mydate between '$_POST[start_date]' and '$_POST[end_date]' "

There is no error,but the result is not I want.

ps:

(1)mydate attribute is timestamp

(2)$_POST[start_date] is something like '2003/05/12'

From: Stephan Szabo
Date: 17 June 2003, 02:18:09
Subject: Re: Trouble porting a Oracle PL/SQL procedure to PL/pgSQL

From: Josh Berkus
Date: 17 June 2003, 03:31:45
Subject: Re: select date range?