Run query on anniversary of a date

[Axrock]

Hi,

I have a table that stores clients with their birthday stored in a date
field 0000-00-00 (EG: YYYY-MM-DD).

I have no idea how to even begin writing a query so that it will select
all birthdays having an anniversary in the selected period.

EG: between now and 7 days for example.

It basically needs to ignore the year and only look at the month and days.

I thought this would have been a really common thing to need to be able
to do, and was hoping Mysql had some fancy function to do it.

Is there?

Many thanks,

Ax

[Jonathan]

Axrock wrote:

Hi,

I have a table that stores clients with their birthday stored in a date
field 0000-00-00 (EG: YYYY-MM-DD).

I have no idea how to even begin writing a query so that it will select
all birthdays having an anniversary in the selected period.

EG: between now and 7 days for example.

It basically needs to ignore the year and only look at the month and days.

I thought this would have been a really common thing to need to be able
to do, and was hoping Mysql had some fancy function to do it.

Is there?

Many thanks,

Ax

There is look in the manual for date functions an example is there.

http://dev.mysql.com/doc/mysql/en/da...culations.html

Look at the bottom of the page just before the user comments at the
examples of finding birthdays (for animals in this case).

HTH

Jonathan

[Axrock]

Hi,

Thanks for that. MySql documentation isn't the easiest to navigate. That
is exactly what i am after.

Ax

Jonathan wrote:

Axrock wrote:

Hi,

I have a table that stores clients with their birthday stored in a
date field 0000-00-00 (EG: YYYY-MM-DD).

I have no idea how to even begin writing a query so that it will
select all birthdays having an anniversary in the selected period.

EG: between now and 7 days for example.

It basically needs to ignore the year and only look at the month and
days.

I thought this would have been a really common thing to need to be
able to do, and was hoping Mysql had some fancy function to do it.

Is there?

Many thanks,

Ax

There is look in the manual for date functions an example is there.

http://dev.mysql.com/doc/mysql/en/da...culations.html

Look at the bottom of the page just before the user comments at the
examples of finding birthdays (for animals in this case).

HTH

Jonathan

[Jonathan]

Axrock wrote:

Hi,

Thanks for that. MySql documentation isn't the easiest to navigate. That
is exactly what i am after.

Ax

Jonathan wrote:

Axrock wrote:

Hi,

I have a table that stores clients with their birthday stored in a
date field 0000-00-00 (EG: YYYY-MM-DD).

I have no idea how to even begin writing a query so that it will
select all birthdays having an anniversary in the selected period.

EG: between now and 7 days for example.

It basically needs to ignore the year and only look at the month and
days.

I thought this would have been a really common thing to need to be
able to do, and was hoping Mysql had some fancy function to do it.

Is there?

Many thanks,

Ax

There is look in the manual for date functions an example is there.

http://dev.mysql.com/doc/mysql/en/da...culations.html

Look at the bottom of the page just before the user comments at the
examples of finding birthdays (for animals in this case).

HTH

Jonathan

You're welcome but a hint for future posts...

A: Because it messes up the order in which people normally read text.
Q: Why is it such a bad thing?
A: Top-posting.
Q: What is the most annoying thing on usenet and in e-mail?

Take a look at topic 6 here:
http://linux.sgms-centre.com/misc/netiquette.php