X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.193]) by svr1.postgresql.org (Postfix) with ESMTP id CB54630F005 for ; Tue, 17 Jun 2003 02:56:35 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (svr1.postgresql.org [64.117.224.193]) (amavisd-new, port 10024) with ESMTP id 11352-07 for ; Mon, 16 Jun 2003 23:56:25 -0300 (ADT) Received: from mail.origo.com.tw (dns.origo.com.tw [218.32.202.201]) by svr1.postgresql.org (Postfix) with ESMTP id BCE0830F008 for ; Mon, 16 Jun 2003 23:56:23 -0300 (ADT) Received: from myko (unknown [172.28.100.201]) by mail.origo.com.tw (Postfix) with SMTP id A57507E26 for ; Tue, 17 Jun 2003 10:45:43 +0800 (CST) Message-ID: <02c101c3347c$1279d830$c9641cac@myko> From: "ko" To: Subject: select date range? Date: Tue, 17 Jun 2003 10:56:38 +0800 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_02BE_01C334BF.2084AE30" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.50.4922.1500 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4925.2800 X-Spam-Status: No, hits=0.4 tagged_above=0.0 required=5.0 tests=HTML_40_50 X-Spam-Level: X-Archive-Number: 200306/167 X-Sequence-Number: 13925 This is a multi-part message in MIME format. ------=_NextPart_000_02BE_01C334BF.2084AE30 Content-Type: text/plain; charset="big5" Content-Transfer-Encoding: quoted-printable Hi, When I use sql statement to select the date range from $_POST value,It does= n'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' ------=_NextPart_000_02BE_01C334BF.2084AE30 Content-Type: text/html; charset="big5" Content-Transfer-Encoding: quoted-printable

Hi,

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

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

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

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

ps:

(1)mydate attribute is timestamp

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

------=_NextPart_000_02BE_01C334BF.2084AE30--