search for partial dates - Mailing list pgsql-general

From James B. Byrne
Subject search for partial dates
Date
Msg-id 45408.216.185.71.24.1244751810.squirrel@webmail.harte-lyne.ca
Whole thread Raw
Responses Re: search for partial dates
Re: search for partial dates
Re: search for partial dates
Re: search for partial dates
List 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@Harte-Lyne.ca
Harte & Lyne Limited          http://www.harte-lyne.ca
9 Brockley Drive              vox: +1 905 561 1241
Hamilton, Ontario             fax: +1 905 561 0757
Canada  L8E 3C3


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: listing relations
Next
From: Christophe
Date:
Subject: Re: search for partial dates