Publisher review:dob2age.sql script shows you how to convert a Date of Birth into the current Age. This script shows you how to convert a Date of Birth into the current Age.
Suppose you have a table People - containing information about .. people, that has a field DoB, which is of the type DATE and that contains the Date of Birth. It is fairly simple to calculate the current age as shown in this script. Of course, NOW() can be substituted for any DATE(TIME) field, or a string of the format YYYY-mm-dd.
dob2age.sql is a SQL script for Database Tools scripts design by Excudo.net.
It runs on following operating system: Windows / Linux / Mac OS / BSD / Solaris.
dob2age.sql script shows you how to convert a Date of Birth into the current Age.
Operating system:Windows / Linux / Mac OS / BSD / Solaris