Re: Obtaining Age

Article View: borland.public.vdbase.data.sql

Article #282

Back to borland.public.vdbase.data.sql Previous Next

#282

From: Ken Chan
Date: Tue, 22 Dec 1998 00:00

19 lines
1242 bytes

Steve Koterski wrote:

> Mm-hmm. That's why I included that "simplistic" reference; as a CYA.

That's what I figured; just wanted to be clear for the lurkers.

> 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.

My preference would be just to return the birthdate, and let the app do 
the calculation, because the birthdate is more useful for calculating the 
age than just the number of days -- with built-in dBASE functions anyway 
-- in combination with today's date.

-- 
//Ken@Inprise
<Please follow-up to newsgroup; do not reply to email>

Technical Details

Message-ID: <MPG.10e9e91ab185406989b77@forums>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

References:

<MPG.10e4a81d2baa73d39897d4@forums.borland.com> <368292e6.6580270@forums.inprise.com> <MPG.10e89aa7a0829577989b73@forums> <368235a1.27562932@forums.inprise.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: supportinfo@inprise.com (Ken Chan)
Subject: Re: Obtaining Age
Date: 1998/12/22
Message-ID: <MPG.10e9e91ab185406989b77@forums>
X-Deja-AN: 425046813
References: <MPG.10e4a81d2baa73d39897d4@forums.borland.com> <368292e6.6580270@forums.inprise.com> <MPG.10e89aa7a0829577989b73@forums> <368235a1.27562932@forums.inprise.com>
Organization: Inprise Corporation
Newsgroups: borland.public.vdbase.data.sql

Reply to Parent Message