Re: birthday calculation - Mailing list pgsql-general

From greg@turnstep.com
Subject Re: birthday calculation
Date
Msg-id 588110ba149afe0ade1dce8d707e532c@biglumber.com
Whole thread Raw
In response to birthday calculation  (Ben <bench@silentmedia.com>)
List pgsql-general
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


> I get their age in days, which doesn't let me take leap years into account.


SELECT extract(year FROM age(user.bday));


- --
Greg Sabino Mullane greg@turnstep.com
PGP Key: 0x14964AC8 200307231714

-----BEGIN PGP SIGNATURE-----
Comment: http://www.turnstep.com/pgp.html

iD8DBQE/HvtGvJuQZxSWSsgRAhhZAJ91pLMPxeKexIPWn8A+heShGLLCOQCeN2/k
Cl4gJIVF7Nakq9hbJrt19pg=
=Gjos
-----END PGP SIGNATURE-----



pgsql-general by date:

Previous
From: nolan@celery.tssi.com
Date:
Subject: Re: Role Models Wanted
Next
From: Karsten Hilbert
Date:
Subject: Re: Role Models Wanted