select birthday query

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
User avatar
itsmani1
Forum Regular
Posts: 791
Joined: Mon Sep 29, 2003 2:26 am
Location: Islamabad Pakistan
Contact:

select birthday query

Post by itsmani1 »

Hi

I am making a birthday database. I have saved date of birth as '12-12-1985' Now i want to select all the birthday that are in December, Need help in query if possible.

Regards,
dizyn
User avatar
onion2k
Jedi Mod
Posts: 5263
Joined: Tue Dec 21, 2004 5:03 pm
Location: usrlab.com

Re: select birthday query

Post by onion2k »

Look at MySQL's "MONTH()" and "YEAR()" functions.
Post Reply