The age function returns the age at the time of timestamp (in completed years) of somebody born on date_of_birth. Can be an expression. The timestamp,or expression resolving to a timestamp, up to which to calculate the completed number of years. Date of birth of the person whose age is being calculated.

This function is used to retrieve the age calculated between the current timestamp value and the specified argument and is returned in terms of years. Months and the total number of days between the two timestamps.

Take the difference between the current day and their birth day: days = current day - birth day . Replace these differences in the age formula: age = (years × 365) + (months × 31) + days . This is the person's age in days. Divide the result by 365 to get the age in years.

The method of calculating age involves the comparison of a person's date of birth with the date on which the age needs to be calculated. The date of birth is subtracted from the given date, which gives the age of the person. i.e., Age formula = Given date - Date of birth.

The AGE function returns a numeric value that represents the number of full years, full months, and full days between the current timestamp and the argument. The schema is SYSIBM. If there is less than a full day between the current timestamp and expression, the result is zero.

The AGE() function takes two timestamps as arguments, subtracts the second timestamp from the first one, and retrieves the resultant interval. The basic syntax of the AGE() function will look like this: AGE(First_TIMESTAMP, Second_TIMESTAMP);