select older than 13

[dadamssg]

i store information about my users in my db. They have the option to give me their first and last name, birthday, male/female, etc. This is all updated by the user in ONE form. By default my date selection list for their birthday is set to Jan 1 2009(the current year). So if they don't want to enter their real birthday that date gets stored automatically. SOO in order to grab useful information i want to grab all the information where their dob is greater than 13 years. how would i use mysql to accomplish this Select query? or does anyone have a better method to not get bs birthdays?

[rhodesa]

how exactly is the date stored in the table? separate fields? DATE datatype? timestamp in an INT?

 

easiest thing to do is post the code for the CREATE TABLE statement

[dadamssg]

Their date of birth is stored in a datetime column.

[mandred]

INTERVAL 13 YEAR

[dadamssg]

how do i use that to grab dates equal to or greater than 13 years from their birthday?

[rhodesa]

try

SELECT * FROM tbl_name WHERE date_col < DATE_SUB(CURDATE(),INTERVAL 13 YEAR)

[dadamssg]

thanks ill try it when i get back to my person computer

[rhodesa]

thanks ill try it when i get back to my person computer

 

you have a computer made from a person? that is awesome!

[dadamssg]

haha yeah...programmed him myself...

 

*PERSONAL*