E
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!
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!