Article View: borland.public.vdbase.data.sql
Article #285Re: Obtaining Age
From: Steve Koterski
Date: Wed, 23 Dec 1998 00:00
Date: Wed, 23 Dec 1998 00:00
21 lines
1627 bytes
1627 bytes
On Mon, 21 Dec 1998 19:11:29 -0800, supportinfo@inprise.com (Ken Chan) wrote: >Steve Koterski wrote: >> You could then use numeric >> arithmetic available in SQL to translate from number of days to number of >> years. One simplistic way would be to divide the number of days by 365.25. > >You realize that will occasionally give you the wrong answer. It is >impossible to accurately determine age in years given the age in days. Mm-hmm. That's why I included that "simplistic" reference; as a CYA. It would probably be best -- given the inherent capabilities in this area of SQL -- to return just the number of days using SQL and then calculate the number of years with the application. ////////////////////////////////////////////////////////////////////////// Steve Koterski "Uhn!" Technical Publications -- Ogg the caveman (c. 10,000BC) INPRISE Corporation http://www.inprise.com/delphi
Technical Details
Message-ID:
<368235a1.27562932@forums.inprise.com>Path:
arc1-ca.pugleaf.net!unknown!not-for-mailReferences:
<MPG.10e4a81d2baa73d39897d4@forums.borland.com> <368292e6.6580270@forums.inprise.com> <MPG.10e89aa7a0829577989b73@forums>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: ff5a1,13e5acd5c576586a X-Google-Attributes: gidff5a1,public From: skoterski@NOSPAMinprise.com (Steve Koterski) Subject: Re: Obtaining Age Date: 1998/12/23 Message-ID: <368235a1.27562932@forums.inprise.com> X-Deja-AN: 425013887 Content-Transfer-Encoding: 7bit References: <MPG.10e4a81d2baa73d39897d4@forums.borland.com> <368292e6.6580270@forums.inprise.com> <MPG.10e89aa7a0829577989b73@forums> Content-Type: text/plain; charset=us-ascii Organization: INPRISE Corporation, Technical Publications Mime-Version: 1.0 Reply-To: skoterski@NOSPAMinprise.com Newsgroups: borland.public.vdbase.data.sql