On Jun 11, 2009, at 1:23 PM, James B. Byrne wrote:
Given a datetime column, not null, is there a single syntax that
permits searching for all dates in a given year, year+month, and
year+month+day such that a single parameterised query can handle all
three circumstances?
Well, of course, in a trivial sense:
SELECT * FROM the_table WHERE datetimecolumn >= $1 AND datetimecolumn
<= $2;
The application has to create the appropriate values for the first and
last days of the year or month in this case, but it's a rare language
that doesn't that facility.
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
