Date vs. Int Column type

[rad2004]

Hello,

I am designing a table which will store among others the members date of birth. Assuming this birthdate column will be used a lot in queries (find member between min.age and max.age) I would appreciate some help in deciding what column type would be better.

1. Date (e.g. 1980-12-01)
2. Int (e.g. 19801201)
3. Any other suggestions?

Thank you

[Vogelfrei]

I prefer to use a DATE type because it will allow me to use MySQL's native date manipulation functions, if necessary.

[r937]

yeah, in this case they would be necessary