search for partial dates

From: "James B(dot) Byrne" <byrnejb(at)harte-lyne(dot)ca>
To: pgsql-general(at)postgresql(dot)org
Subject: search for partial dates
Date: 2009-06-11 20:23:30
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-general

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?

*** E-Mail is NOT a SECURE channel ***
James B. Byrne mailto:ByrneJB(at)Harte-Lyne(dot)ca
Harte & Lyne Limited
9 Brockley Drive vox: +1 905 561 1241
Hamilton, Ontario fax: +1 905 561 0757
Canada L8E 3C3


Browse pgsql-general by date

  From Date Subject
Next Message Christophe 2009-06-11 20:30:15 Re: search for partial dates
Previous Message Tom Lane 2009-06-11 20:14:14 Re: listing relations