Re: select date range?

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: "ko" <ko(at)origo(dot)com(dot)tw>, <pgsql-sql(at)postgresql(dot)org>
Subject: Re: select date range?
Date: 2003-06-17 03:28:46
Message-ID: 200306162028.46202.josh@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Ko,

> (1)mydate attribute is timestamp
> (2)$_POST[start_date] is something like '2003/05/12'

You probably need to re-format the POST date before passing it to the
back-end. For example, my compilation of PostgreSQL would not necessarily
correctly recognize that date format.

Try re-formatting the date to '2003-05-12'

--
Josh Berkus
Aglio Database Solutions
San Francisco

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Ramil G. Sagum 2003-06-17 03:43:47 Re: select date range?
Previous Message ko 2003-06-17 02:56:38 select date range?