Article View: borland.public.vdbase.data.sql
Article #269Re: Obtaining Age
From: Gerald Lightsey
Date: Sun, 20 Dec 1998 00:00
Date: Sun, 20 Dec 1998 00:00
18 lines
1201 bytes
1201 bytes
In article <75ia5q$5ge2@forums.borland.com>, ghill@n2.net says... > It might the hard way but you should be able to start with the following: > > Select EXTRACT(YEAR FROM DOB) FROM MYTABLE ALIAS CYEAR > Select EXTRACT(DAY FROM DOB) FROM MYTABLE ALIAS CDAY > Select EXTRACT(MONTH FROM DOB) FROM MYTABLE ALIAS CMONTH > > Of course you could store the above information to Vars and then do some > math on the Vars with what ever language you choose. > Greg, Thanks. That is essentially what I have done. I just thought since Age is a common, but nearly always calculated value, someone has surely come up with a version 5.6 Local SQL routine that is more elegant than rolling my own. Gerald
Technical Details
Message-ID:
<MPG.10e720775f118c419897d6@forums.borland.com>Path:
arc1-ca.pugleaf.net!unknown!not-for-mailReferences:
<MPG.10e4a81d2baa73d39897d4@forums.borland.com> <75ia5q$5ge2@forums.borland.com>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: ff5a1,13e5acd5c576586a X-Google-Attributes: gidff5a1,public From: glightsey@cari.net (Gerald Lightsey) Subject: Re: Obtaining Age Date: 1998/12/20 Message-ID: <MPG.10e720775f118c419897d6@forums.borland.com> X-Deja-AN: 424327840 References: <MPG.10e4a81d2baa73d39897d4@forums.borland.com> <75ia5q$5ge2@forums.borland.com> Organization: Another Netscape Collabra Server User Newsgroups: borland.public.vdbase.data.sql