Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Age calculation !!!
- Thread starter mstr1
- Start date
simplest calculation expression is
Year(CurrentDate()) - year(Birthdate)
The Int Server will resolve it to the appropriate teradata syntax for you.
However, it does not take into account exact dates. Another choice is to use the following expression
int((birthdate - currentdate())/365)
good luck.
Year(CurrentDate()) - year(Birthdate)
The Int Server will resolve it to the appropriate teradata syntax for you.
However, it does not take into account exact dates. Another choice is to use the following expression
int((birthdate - currentdate())/365)
good luck.
- Thread starter
- #3
- Status
Similar threads
- Locked
- Question