Convert number to date


el zorro

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!

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question