Birthday search.

From: Antti Linno <alligator(at)all(dot)ee>
To: pgsql-sql(at)postgresql(dot)org
Subject: Birthday search.
Date: 2001-03-22 14:50:33
Message-ID: Pine.LNX.4.04.10103221647520.4786-100000@all.ee
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

I have a table with personal data, including date of birth in date format.
What i need is a select that searches birthdays in certain range.
E.g. I need to find all birthdays starting from 15.april until 20th
december. As you all understand, year doesn't matter :P
Any simple and elegant solutions to it?

Greetings,
Antti

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2001-03-22 15:05:37 Re: CHAR or VARCHAR
Previous Message Richard Huxton 2001-03-22 14:42:12 Re: how to build this string ?