| 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: | Whole Thread | Raw Message | 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 |