Postgres Pro
Downloads
Home   >   mailing lists

Re: Age function - Mailing list pgsql-general

From Rich Shepard
Subject Re: Age function
Date
Msg-id Pine.LNX.4.64.0705141325580.6830@salmo.appl-ecosys.com
Whole thread Raw
In response to Age function  ("Andrus" <kobruleht2@hot.ee>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Postgres Printed Manuals
Next
From: Bill Moseley
Date:
Subject: Performance issues of one vs. two split tables.