From: ko <ko@origo.com.tw>
To: pgsql-sql@postgresql.org
Subject: select date range?
Date: Tue, 17 Jun 2003 10:56:38 +0800
Message-ID: <02c101c3347c$1279d830$c9641cac@myko> (raw)
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'
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: ko@origo.com.tw
Subject: Re: select date range?
In-Reply-To: <02c101c3347c$1279d830$c9641cac@myko>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox