Is there a way to convert a 6-digit number to mmddyy?

Background: THe date of birth of people ionm our database is hidden in an ID
number we assign to them. I used SUBSTRING () to extract the portion of the
ID that has the birthdate. Norw I want to get the database to recognize that
as a date, so that I can perfrom a date operation on it (such as, finding
everyone who is over 65 years old by subtracting their birthdate from today).
ADP/SQL setup. Your help is appreciated. Thanks!

tahmks
"el zorro" <(E-Mail Removed)> wrote in message
news:4E87CBDB-5EC5-4306-BF63-(E-Mail Removed)...
> Is there a way to convert a 6-digit number to mmddyy?
>
> Background: THe date of birth of people ionm our database is hidden in an
> ID
> number we assign to them. I used SUBSTRING () to extract the portion of
> the
> ID that has the birthdate. Norw I want to get the database to recognize
> that
> as a date, so that I can perfrom a date operation on it (such as, finding
> everyone who is over 65 years old by subtracting their birthdate from
> today).
> ADP/SQL setup. Your help is appreciated. Thanks!
>
>