select date range?

From: "ko" <ko(at)origo(dot)com(dot)tw>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: select date range?
Date: 2003-06-17 02:56:38
Message-ID: 02c101c3347c$1279d830$c9641cac@myko
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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'

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Josh Berkus 2003-06-17 03:28:46 Re: select date range?
Previous Message Stephan Szabo 2003-06-17 02:17:57 Re: Trouble porting a Oracle PL/SQL procedure to PL/pgSQL