How to calculate a person's age?

Posted in 1997

"Ing. Melvin Perez Cedano" — 5 Sep 1997 12:53:07 -0400 — source: Informix-list mailing list archive (1991-1998)

Hi all: I trying to calculate how old are a person. I have the birth date in a column. I have been using a DATETIME YEAR TO YEAR variable in my program and asigning to it the result of (TODAY - birthdate) UNITS YEAR it returns NULL. I have done using an INTEGER variable without UNITS clause and it returns the number of days. I know I could divide this number between 365/366 and get the number of years, but I would like to get more presision. How have you done this? -- ////// +---------------------------ooo-O-O-ooo--------------------------------+ | U | | Melvin Perez Cedano Santo Domingo, Dom. Rep.| | Vice-President cam@codetel.net.do | | Systems Development Phone (809) 686-5574 | | CAM Informatica, S. A. Fax (809) 686-5467 | +----------------------------------------------------------------------+ | ALL RIGHTS RESERVED | | This posting is copyright and may be used only for the purposes | | of professional study or the professional exchange of information. | | Use of this posting by any commercial organisation for the | | purposes of vilifying another is explicitly prohibited. | +----------------------------------------------------------------------+