Re: Age function

From: Rich Shepard <rshepard(at)appl-ecosys(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Age function
Date: 2007-05-14 20:32:00
Message-ID: Pine.LNX.4.64.0705141325580.6830@salmo.appl-ecosys.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, 14 May 2007, Andrus wrote:

> How to create function which returns persons age in years?

Look at the PostgreSQL docs for "Date/Time Functions and Operators."
You'll find the syntax for AGE() there.

Rich

--
Richard B. Shepard, Ph.D. | The Environmental Permitting
Applied Ecosystem Services, Inc. | Accelerator(TM)
<http://www.appl-ecosys.com> Voice: 503-667-4517 Fax: 503-667-8863

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Bill Moseley 2007-05-14 20:37:18 Performance issues of one vs. two split tables.
Previous Message Bruce Momjian 2007-05-14 20:26:25 Re: Postgres Printed Manuals