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
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 |