BirthDay SQL Issue

From: brett <bhalligan(at)yahoo(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: BirthDay SQL Issue
Date: 2005-10-01 22:32:05
Message-ID: ji3uj1lqok26mll7bugc8rhpqk56s45m6j@4ax.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi there

This is my first posting here, please forgive me if I make any
mistakes here.

Ok

I have the structure

{CLIENTS} = Client ID, First Name, Surname, DOB, Address, Home Phone
No, Mobile Phone No

As one relation / table (There are several others in this db that are
not related to this issue)

My problem is this

I need to be able to select two dates on my webby so I have a range of
dates

E.G. (using English date format DD/MM/YYYY)

01/09/2005 to 01/10/2005

Then I want to be able to get, using some nifty query, everyone's
birthday that falls between those two dates. So if someone's birthday
was 04/09/79 it would return that tuple

I have been stuck on this for ages. Any my search for help has brought
me here.

If anyone out there can help me, in any way, I would be very grateful.

Kind regards
Brett Halligan

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Cenk KIZILDAG 2005-10-02 13:30:31 Getting user created tables from SQL
Previous Message Michael Fuhr 2005-09-30 23:34:17 Re: EXECUTE with SELECT INTO variable, or alternatives