search by year of birthday

[teddmcload]

i have birthdays of my members. and i want to have which of my members are 20 years old or 30 years old?

i stored birthday informations at the database like 1978-12-10. and i want to know what is the sql string for this date style? i want to know which of members burned in 1978 or 1970?

[AstroTeg]

You didn't specify which database engine you're using, so I'm going to use MySQL as an example.

You could just do:

SELECT membername FROM membertable WHERE YEAR(memberbirthday) = 1978

YEAR() will just return the year part and you can search on that. Or if you wanted, you could do some math and subtract todays date from the YEAR() value to find all those years that equal 20 or 30 (there maybe a datediff() function which might be better for this task since it would take into account month and day).

[teddmcload]

sorry...

u r right.

i am using mysql

thank you... 😉

[keith73]

Originally posted by teddmcload
i have birthdays of my members. and i want to have which of my members are 20 years old or 30 years old?

i stored birthday informations at the database like 1978-12-10. and i want to know what is the sql string for this date style? i want to know which of members burned in 1978 or 1970?

what data type is the column that the date is being stored in. is it date or datetime?

• keith

[teddmcload]

it is date .